Forum Discussion

bedata1's avatar
bedata1
Frequent Visitor
3 years ago
Solved

DAX if statement has no / wrong total

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!

DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    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 )
    )

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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 )
    )