Stacked Column Chart made up of created column data show timefram values as percentages

[mibu]

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

[Ashish_Mathur]

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.

[mibu]

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

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[mibu]

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

[Ashish_Mathur · Accepted 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.

[mibu]

@Ashish_Mathur.  Your measure worked beautifully.  Thank you so much!  very best, mibu

[Ashish_Mathur]

You are welcome.

[affan]

Hi @mibu

Please share some data and expected result, so that I can share a solution with you