topic Re: DAX if statement has no / wrong total in DAX Commands and Tips

DAX if statement has no / wrong total

bedata1 — Sun, 20 Nov 2022 20:31:59 GMT

Hi Community,

I have created an if DAX where the total is not displayed:

First I created the following DAX called "Effizienz":

Effizienz =

DIVIDE(

SUM('Projektposten'[Quantity]),

SUM('Projekt-Budgetposten'[Quantity])

)

Second I used this in another DAX calles "100%":

100% = if( and([Effizienz]<=1.1, [Effizienz]>0.8),1,0)

Now I actually expect it to show me the totalization (see printscreen above).

Can someone help me how to get the total displayed?

Thanks for your help!

FreemanZ — Sun, 20 Nov 2022 22:09:05 GMT

the totalization of what?

tamerj1 — Mon, 21 Nov 2022 04:00:46 GMT

you can force additivity using

100% =
SUMX (
VALUES ( 'Table'[No] ),
VAR Efficiency = [Effizienz]
RETURN
IF ( AND ( Efficiency <= 1.1, Efficiency > 0.8 ), 1, 0 )
)

bedata1 — Mon, 21 Nov 2022 19:25:04 GMT

tamerj1 incredibly good support, thank you very much!