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 ) )
visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Hi Anonymous,

 

Try the following method,

 

CALUALTE( COUNTROWS(Date[Date]), FILTER(Date[Date], Measure>45))

 

Hope this works out for you and if it doesn't, please share a PBIX.

 

Thank you,

Vishesh Jain

Anonymous's avatar
Anonymous
Not applicable
3 years ago

visheshjain appriciate your time on this, it is not working as i expected. but thanks for your time.