Show value of specific value in %

[MHC]

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]

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"

[MHC]

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")))