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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tamerj1 ,
There is a problem here is the result I get. I should have mentioned that each record is in the data multiple times.
Is there any way to fix it?

 

 

 

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

Anonymous 

What DAX have you used? Can you paste a screenshot?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Its now fixed because I used the column you showed me how to do in the last post. THANK YOU!!!!