Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count not returning expected result

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.
 
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous 

    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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

       

      Thks for reply.

       

      No luck with your column. Getting results of -

       

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous 

         

        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