Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Divide with filters error

Hallo, I've got a problem with this table.   https://www.dropbox.com/s/ii6q02bn9kltvef/Cartel1.xlsx?dl=0    iN this file we have are 2 tables: 1: Carico_4 2: Carico_uph   Ive made the second...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    Try modifying your DAX as follows:

    UPH_XD = divide(

    calculate(sum(Carico_uph[contenitori]), filter(ALLSELECTED(Carico_uph), Carico_uph[CIRCUITO]="XD")), calculate(sum(Carico_uph[op nr]), filter(ALLSELECTED(Carico_uph),Carico_uph[CIRCUITO]="XD")), 0

    )

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

Try modifying your DAX as follows:

UPH_XD = divide(

calculate(sum(Carico_uph[contenitori]), filter(ALLSELECTED(Carico_uph), Carico_uph[CIRCUITO]="XD")), calculate(sum(Carico_uph[op nr]), filter(ALLSELECTED(Carico_uph),Carico_uph[CIRCUITO]="XD")), 0

)

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    I filled in ur formula:

    UPH_XD = divide(

    calculate(sum(Carico_uph[contenitori]), filter(ALLSELECTED(Carico_uph), Carico_uph[CIRCUITO]="XD" || Carico_uph[CIRCUITO]="XK")), calculate(sum(Carico_uph[op nr]), filter(ALLSELECTED(Carico_uph),Carico_uph[CIRCUITO]="XD" || Carico_uph[CIRCUITO]="XK")), 0

    )
    But the output is wrong yet
    tot contenitori: 546
    ttot op nr= 88
    it should be 6,2 but it is 8,28