DAX if statement has no / wrong total

[bedata1]

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!

[tamerj1 · Accepted solution]

Hi @bedata1 

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]

@tamerj1  incredibly good support, thank you very much!

[FreemanZ]

the totalization of what?