Forum Discussion
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 want another measure where count of value >45
so finally i want to seee out put as we have 4 days where value is >45.
how to acheive this?
amitchandak Pragati11 denxx34 Anonymous Anonymous visheshjain
| date | value |
| 01-02-2022 | 59 |
| 02-02-2022 | 60 |
| 03-02-2022 | 45 |
| 04-02-2022 | 40 |
| 05-02-2022 | 35 |
| 06-02-2022 | 78 |
| 07-02-2022 | 90 |
Hi Anonymous
Please tryCount = SUMX ( VALUES ( 'Table'[Date] ), IF ( [Value] > 45, 1 ) )
4 Replies
Hi Anonymous
Please tryCount = SUMX ( VALUES ( 'Table'[Date] ), IF ( [Value] > 45, 1 ) )tamerj1 thanks for your time, this solution is working for me.
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
visheshjain appriciate your time on this, it is not working as i expected. but thanks for your time.
