Count not returning expected result

[Qotsa]

Hi,

I have this measure - 

Wages as % of Invoiced = DIVIDE([Wages],[Invoiced],0)

I want a total of client_id where this measure is < .6

I am using -

Less than .6 = CALCULATE(DISTINCTCOUNT('powerbi114 view_finance'[client_id]),FILTER('powerbi114 view_finance',[Wages as % of Invoiced] < .6))

But results are not what I expect. See example.

[Anonymous]

@Qotsa 

Measure only calculates the current row. Your formula should work with column.

Try add All(table) in the filter:

Measure = CALCULATE(DISTINCTCOUNT('powerbi114 view_finance'[client_id]),FILTER('powerbi114 view_finance',[Wages as % of Invoiced] < .6),ALL('Table'))

Paul Zheng

If this post helps, please consider Accept it as the solution to help the other members to find it.

[Qotsa]

@Anonymous 

Thks for reply.

No luck with your column. Getting results of -

First pic is Don't Summarize. The 2nd is using SUM.

[Anonymous]

@Qotsa 

My formula should also work with measure. Isn't 1582 is your expected count of client that < 0.6?

If not, please share a sample pbix with expected result. 

Paul