Show value of specific value in %

MHC · ‎05-23-2018

Hi,

In Excel Pivot you are able to "Show values As" -> "% Of" -> choose Base field and specific Base item.

Is this possible in Power BI?

Thanks in advance for the help!!

Regards,

MH

Greg_Deckler · ‎05-23-2018

Yes, once you put a column in your Values area, click the little drop down arrow that appears there and choose "Show As...Percent of Total"

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

MHC · ‎05-23-2018

Yes correct but what I am looking for is like the example below in excel - base field is Brand and Base item is Brand A.

The formula is Brand A divide by Brand A, Brand B divide by Brand A, Brand C divide by Brand A.

I have this formula but I am missing something:

% of Brand A =
DIVIDE (
[Average of price],
CALCULATE ( [Average of price], ALLSELECTED(),SELECTEDVALUE('B2B 2017 - 2018 week 11'[brand],"A")))

Helpful resources