Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to show multiple measure in single measure

Hi experts,

I have 2 measure 

1- Units

2-Volume

I want to show this on slicer if I click on units then dashboard's data could change basis on units and if i click on volume then change on volume.

Please help me on this.

@Greg_Deckler @amitchandak @Tanushree_Kapse 

Thanks.

1 ACCEPTED SOLUTION
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @Anonymous ,

 

Try this measure:

Measure= IF(CONTAINS(Table[Slicer_column]) ="Units", Units, IF(CONTAINS(Table[Slicer_column])= "Volume", Volume))

 

I hope this helps.

If I answered your question, mark it as solution. Kudos are always appreciated.

Thanks!

 

 

 

 

 

View solution in original post

4 REPLIES 4
Tanushree_Kapse
Impactful Individual
Impactful Individual

Hi @Anonymous ,

 

Try this measure:

Measure= IF(CONTAINS(Table[Slicer_column]) ="Units", Units, IF(CONTAINS(Table[Slicer_column])= "Volume", Volume))

 

I hope this helps.

If I answered your question, mark it as solution. Kudos are always appreciated.

Thanks!

 

 

 

 

 

Anonymous
Not applicable

Thank you so much tanushree. 

Actually I am too friendly with Tableau but facing issues in Power BI but now smoothly learning. 

 

Anonymous
Not applicable

I have created two measure like Unit and Volume

I want to show this on slicer so user can easily can see basis on Units or Volums after clicking one by one.

 

@Anonymous ,

Create a new table... with two rows.

Units 

Volume 

Use this column in your slicer. 

Then use this measure in your visuals in values. 

Measure= IF(CONTAINS(Table[Slicer_column]) ="Units", Units, IF(CONTAINS(Table[Slicer_column])= "Volume", Volume))

 

 

 

 

 

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors