cancel
Showing results for
Did you mean:
Regular Visitor

## Slicer for Multiple Measures

Hi All,

I have a  Slicer that dynamically selects Measures.I was able to achive this for a Single Measure but now i have to display 4 measures when single measure is selectedin slicer .How do I achive this.?

Eg:when Count of Items is selected in the slicer,the graph should display 4 measure(one month Avg,two month avg....) line need to displayed.  for Count of Items

I was able to do it for single measure and single calculation using the below

Steps done so far:

1)Create a table with measure to be displayed in Slicer.

2) Create a  Measure column for 1 Month Avg (which Includes switch for the 6 measure) as shown below

SWITCH([Selected Measure Avg],[Item Count ],CALCULATE(SUM(Tab1[c1]),(T1[c2]>0),
ALLEXCEPT(T1,T1[C3],T1[C4]))/CALCULATE(SUM(T1[C1]),(T1[C5]=0),ALLEXCEPT(T1,T1[C6])),

[Product Countl],............),

3)Replicated the same for 3 month Avg ,6month Avg and 12 month Avg..........

When i select Item count in slicer,I get only only one line showing the 1 month avg...

Regards,

Raj

3 REPLIES 3
Community Support

Hi @Rtum ,

I think this scenario is currently not supported.

In SWITCH(), one  condition has one value. And measure  always returns a single value.

``=SWITCH(MAX('Selection'),"1 Month",[M1],"2 Month",[M2])``

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

Super User

@Rtum ,Based on what I got

That means 4 measure has to be created using the measure slicer

So 4 measure has use the value of slicer

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Regular Visitor

Yes, when i select  Item Count from Slicer,I need the graph below to show me four lines (1Month Avg,3 Month Avg,6 month Avg,12 month avg)....

I created 4 measures(one for each month Avg) using switch ( for 6 slicer measures)...anything i am missing?

Announcements