topic Re: Need some help on writing a measure to count numbers of bars. in DAX Commands and Tips

Need some help on writing a measure to count numbers of bars.

Anonymous — Thu, 30 May 2024 18:31:45 GMT

Hi I am still new to DAX and I feel like it should be an easy DAX to write but I tried and couldn't figure it out.
I have a chart below, I want to have a measure that counts the number of bars that is below the target, these two green bars, in this case, it should retunrs "2" as the result.

Thanks!!

Re: Need some help on writing a measure to count numbers of bars.

gmsamborn — Thu, 30 May 2024 19:28:43 GMT

Hi Anonymous

I'm not sure where you got your target so I hard coded it to be 8.

These measures should help.

Target = 8 Shifts = SUM( 'Table'[# of Shifts] ) Below = COUNTROWS( FILTER( 'Table', [Shifts] <= [Target] ) )

Let me know if you have any questions.

bwang2.pbix