Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need count based on measure value

HI,   i need count of value per date but the value is coming from a measure. as you can see below we have diff dates and value for each day. value is coming from a different dax measure. so i wa...
Need Dax
Need Help DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Count =
SUMX ( VALUES ( 'Table'[Date] ), IF ( [Value] > 45, 1 ) )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
Please try

Count =
SUMX ( VALUES ( 'Table'[Date] ), IF ( [Value] > 45, 1 ) )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    tamerj1 thanks for your time, this solution is working for me.