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

[Anonymous]

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!!

[gmsamborn · Accepted solution]

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