Adding a % of column on a field measure

[Anonymous]

Hello Community  -  Modifying my original post to better explain what I am trying to do.  

Creating a field measure with these 4 options is easy and of course you end up with a slicer  that has these 4 options.  However, I only want to show two of them because what I actually want is when the user selects Quantity...the matrix visual should show Quantity and % of Qty.   If they select Revenue, then the matrix should only show Revenue and % of Rev.    I don't want to show all 4 options.   

Perhaps I am going about this the wrong way, but I was hoping I could utilize field parameters to essentially mimic the behavior of adding the Revenue measure twice..and then having the 2nd one be the "show as % of column" option.  

GDP Measures = {

    ("Quantity", NAMEOF('Global Demand Table'[Sum of GDP Quantity]), 0),

    ("% of Qty", NAMEOF('Global Demand Table'[% of Total_GDP Quantity]), 1),

    ("Revenue", NAMEOF('Global Demand Table'[Value by Revenue Recognition Date]), 2),

    ("% of Rev", NAMEOF('Global Demand Table'[% of Total_Revenue by Recognition Date]), 3)

}

[Anonymous]

@v-jianboli-msft     Perfect solution!!   So easy, and clean.   I asked ChatGPT this same question and it gave me a bunch of ridiculous solutions....

Thank you!

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

First add a new column to the parameter table:

Then create a new sliceer with the Flag column:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.