Further "How to display different measures using a selector"

[Anonymous]

Hi Power BI experts,

To diplay different measures using a selector, this is a fantastic solution from Phil Seamark (https://community.powerbi.com/t5/user/viewprofilepage/user-id/3459)

https://community.powerbi.com/t5/Desktop/How-to-display-different-measures-using-a-selector/m-p/1317...

I'd like to hear your thoughts if it's still possible to further advance Phil's solution by adding additional slicer to it.

Is it still possible to apply or add more slicers from Phil's solution?

For example, I've got measures: Sales Value, Margin and Quantity.

I was able to apply Phil's solution on selecting these measures.  But would it still be possible to add more slicer on top?

Like after applying Phil's solution, I'd still be able to select the different dimensions (e.g. Product Brand)?

Phil's solution was able to select the measures and also used the "Date" range to be able to slice further (using two slicers) in his sample.

Warm regards,

- Louis

[v-chuncz-msft]

@Anonymous,

In short, yes, you may do research into the measures dragged to Values and Visual level filters.

[Anonymous]

Hi Sam,

I guess it's not possible to further advance Phil's solution because it uses the SUMMIZECOLUMN funciton.  And I want to furhter filter it using slicers.  Is that right from this post?

https://community.powerbi.com/t5/Desktop/Slicer-with-SummarizeColumn/td-p/366295

Anyone wants to support this idea, kindly vote?
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19727836-slicer-for-measures

Cheers,

Louis

[Anonymous]

Hi Sam,

Could you give me more hints how to do it?

Currently, I am putting my measures in a temporary table as different summed up variables.  And then using SWITCH to switch between these summed up measures.

I've been trying to add the [Brand] as a FILTER in my CALCULATION and SUM but I am not doing it right or it should be a different function?

Cheers,

- Louis