Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Summing a measure

  Hi All, Hope everyone is having a good weekend. I am having a hard time summing a measure, hoping someone can help me. The measure I have on a metrix visual is: Greater than 3 Days = IF([Networ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    please try

    Greater than 3 Days =
    SUMX ( VALUES ( 'Table'[Name] ), IF ( [NetworkingDays] > 3, 0, 1 ) )

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

Hi Anonymous 

please try

Greater than 3 Days =
SUMX ( VALUES ( 'Table'[Name] ), IF ( [NetworkingDays] > 3, 0, 1 ) )