Need count based on measure value

[johnbasha33]

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 @duncanmi @RobHofker @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

[tamerj1 · Accepted solution]

Hi @johnbasha33 
Please try

Count =
SUMX ( VALUES ( 'Table'[Date] ), IF ( [Value] > 45, 1 ) )

[johnbasha33]

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

[visheshjain]

Hi @johnbasha33,

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

[johnbasha33]

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