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'[Quanti...
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 )
    )

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

  • bedata1's avatar
    bedata1
    Frequent Visitor
    3 years ago

    tamerj1  incredibly good support, thank you very much!