Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Community,
I have a Stacked Column Chart made up of created column data, binary in nature: data for each line item is either Yes or No.
I want to show Yes and No as a percentage of their total count... for timeframe indicated, either week or month.
Thoughts on how to get what are now two numbers showing with percentages?
Thanks!
mibu
Solved! Go to Solution.
Hi,
The measure should be
=CALCULATE(SUM(FactData[Units]),FactData[M/NM]="M")/CALCULATE(SUM(FactData[Units]),ALL(FactData[M/NM]))
Hope this helps.
Hi,
Try this
Measure=COUNTROWS(Data)/CALCULATE(COUNTROWS(Data),ALL(Data[Response]))
Response is the Name of the column which has Yes/No. Data is the name of the Table.
Hope this helps.
Thanks @Ashish_Mathur!
Meausre looks like:
Measure=COUNTROWS(TableName)/CALCULATE(COUNTROWS(TableName),ALL(TableName[ColumnName]))
I get no errors in the measure... but output looks as follows... 100% for each (Yes and No), rather than correct percentage of each for timeframe indicated.
Note: Reiterating that data in ColumnName is a custom column, created by Custom column formula...
Look forward to your feedback. Thanks! mibu
Hi,
Share the link from where i can download your PBI file.
You may download test file here:
https://www.dropbox.com/sh/0lvrflyn90zrvxv/AACd0m-xGh7sN1Lar3teolZQa?dl=0
For example: First week of Aug 2017... the percentage, as indicated by red line (Line values = measure MM) should be: 13.6% (24/176).
Thanks and best,
mibu
Hi,
The measure should be
=CALCULATE(SUM(FactData[Units]),FactData[M/NM]="M")/CALCULATE(SUM(FactData[Units]),ALL(FactData[M/NM]))
Hope this helps.
@Ashish_Mathur. Your measure worked beautifully. Thank you so much! very best, mibu
You are welcome.
Hi @mibu
Please share some data and expected result, so that I can share a solution with you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |