Forum Discussion

Clout's avatar
Clout
Icon for Helper III rankHelper III
5 years ago
Solved

Incorrect result when dividing with counted columns

Hello guys, I have this DAX Function as a calculated column :   Spalte = IF(ISBLANK(Frachten[AK_C_P]), BLANK(), DIVIDE(COUNTROWS(FILTER(Frachten, Frachten[AK_C_P] <= MAX('Global'[GW_AblaufPges...
  • Clout's avatar
    Clout
    5 years ago

    Hello thank you for your answer,

    but I got this solution now:

     

    RM_NH4 = VAR numerator = CALCULATE(COUNTROWS(Frachten),FILTER(Frachten, Frachten[AK_C_NH4] <> Blank() && Frachten[AK_C_NH4] <= Max('Global'[GW_AblaufNH4N]))) VAR denominator = COUNT(Frachten[AK_C_NH4]) RETURN DIVIDE(numerator, denominator)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Clout , I think it should be like this measure

 

DIVIDE(COUNTROWS(FILTER(allselected(Frachten), Frachten[dataum] <= MAX('Global'[dataum]))), calculate(COUNT(Frachten[AK_C_P]),allselected(Frachten)))

Clout's avatar
Clout
Icon for Helper III rankHelper III
5 years ago

Hello thank you for your answer,

but I got this solution now:

 

RM_NH4 = VAR numerator = CALCULATE(COUNTROWS(Frachten),FILTER(Frachten, Frachten[AK_C_NH4] <> Blank() && Frachten[AK_C_NH4] <= Max('Global'[GW_AblaufNH4N]))) VAR denominator = COUNT(Frachten[AK_C_NH4]) RETURN DIVIDE(numerator, denominator)