Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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