Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have the measure to count how many members have that ppl category.
Solved! Go to Solution.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Great thank you!
Also i would like to calculate the % e.g No of Members / Total. How can this be written. I have a measure and it isnt taking into account the correct figures.
Hi, @yaman123
Thank you for your feedback.
I think the distinctcount/allselect in %PPL measure = counting all members including zero sales.
I think this percentage is also useful, but if you don't need this, then you can distinct count all members who has non-zero-sales. Something like below...
calculate (
COUNTROWS (
FILTER (
VALUES ( 'Payment by Member Query'[MEMBER_CODE] ),
NOT ISBLANK ( [Total PPL] )
), allselected(PPLBUCKET)
)
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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:
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
hI @Jihwan_Kim
Theres a lot of private information in the file. I can share the table and measures.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim
I think i have solved this. I have created a new measure
User | Count |
---|---|
136 | |
73 | |
73 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
63 | |
63 | |
51 |