Forum Discussion

yaman123's avatar
yaman123
Post Partisan
5 years ago
Solved

Incorrect Total in table

Hi,    I have the measure to count how many members have that ppl category.  No of Members = (IF([Total PPL] = BLANK(),BLANK(),CALCULATE(DISTINCTCOUNT('Payment by Member Query'[MEMBER_CODE])))) ...
Need Help
Show and Tell
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, yaman123 

    Please try the below measure.

     

    No of Members =
    COUNTROWS (
    FILTER (
    VALUES ( 'Payment by Member Query'[MEMBER_CODE] ),
    NOT ISBLANK ( [Total PPL] )
    )
    )

     

    Hi, My name is Jihwan Kim.

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

yaman123's avatar
yaman123
Post Partisan
5 years ago

Hi Jihwan_Kim 

 

I am getting the results as 1 instead of the percentage 

 

Sorry if i am not writing the dax query correctly, i have the below query:

 

Measure = [No of Members]/CALCULATE(COUNTROWS(FILTER(VALUES('Payment by Member Query'[MEMBER_CODE]),NOT ISBLANK([Total Milk PPL]))),ALLSELECTED('Payment by Member Query'[MEMBER_CODE]))
 
 
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi,

if it is OK with you, please share the sample pbix file, then I can try to come up with a more accurate mesure.

 

thanks.

 

Hi, My name is Jihwan Kim.

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

  • yaman123's avatar
    yaman123
    Post Partisan
    5 years ago

    hI Jihwan_Kim 

     

    Theres a lot of private information in the file. I can share the table and measures.

     

    Measure = [No of Members]/CALCULATE(COUNTROWS(FILTER(VALUES('Payment by Member Query'[MEMBER_CODE]), NOT ISBLANK([Total Milk PPL]))),ALLSELECTED())
     
    % PPL = [No of Members]/CALCULATE(DISTINCTCOUNT('Payment by Member Query'[MEMBER_CODE]),ALLSELECTED())
     
    No of Members =
    COUNTROWS (
    FILTER (
    VALUES ( 'Payment by Member Query'[MEMBER_CODE] ),
    NOT ISBLANK ( [Total Milk PPL] )
    )
    )
    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, terribly sorry to say that please check your last measure.

      Is it giving the result = 1 ??

      When I tested it, it gave me an error.

       

      • yaman123's avatar
        yaman123
        Post Partisan
        5 years ago

        Hi Jihwan_Kim 

         

        I think i have solved this. I have created a new measure 

         

        Total No of Members = CALCULATE(COUNTROWS(FILTER(VALUES('Payment by Member Query'[MEMBER_CODE]),NOT ISBLANK([Total Milk PPL]))),ALLSELECTED())
         
        then i create another measure to divide by no of members. 
         
        Measure = [No of Members]/[Total No of Members]
         
        Is it probably a long winded way of doing it but it gives me the correct figures in the table. 
         
        Thanks for your help, much appreciated!