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.

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!