cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

TWO MEASURES AT THE SAME CARD ACCORDING TO THE FILTER SELECTED

Dear All,

 

I need to get a filter with the options below:

- Monthy Turnover

- Monthly Turnover vs. previous year

 

And the cards need to change according to the option selected - that means I have two different measures at the same card, but changing depending on the calculation selected.

 

How can I do that, please?

 

And second option...

Is it possible to have different distribution lists for different sheets?

 

Thank you in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @ANE2CAbo 

You may build a slicer Table as below and build a measure to achieve your goal : show different result if you select different options.

Slicer Table

1.png

Measure:

Measure = 
Var _Sel = SELECTEDVALUE(Slicer[Option])
Var _Monthy_Turnover = 1
Var _Monthly_Turnover_vs_previous_year = 2
Return
IF(HASONEFILTER(Slicer[Option]),IF(_Sel = "Monthy Turnover",_Monthy_Turnover,_Monthly_Turnover_vs_previous_year),"")

Due to I don't know your data model and the measure you build, so in my measure I use 1 and 2 to replace your measure in var.

Result is as below. The card visual will show different result by select options in slicer.

Option = Monthly Turnover vs. previous year

1.png

Option = Monthy Turnover

2.png

Best Regards,

Rico Zhou

 

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

 

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Community Support
Community Support

Hi @ANE2CAbo 

You may build a slicer Table as below and build a measure to achieve your goal : show different result if you select different options.

Slicer Table

1.png

Measure:

Measure = 
Var _Sel = SELECTEDVALUE(Slicer[Option])
Var _Monthy_Turnover = 1
Var _Monthly_Turnover_vs_previous_year = 2
Return
IF(HASONEFILTER(Slicer[Option]),IF(_Sel = "Monthy Turnover",_Monthy_Turnover,_Monthly_Turnover_vs_previous_year),"")

Due to I don't know your data model and the measure you build, so in my measure I use 1 and 2 to replace your measure in var.

Result is as below. The card visual will show different result by select options in slicer.

Option = Monthly Turnover vs. previous year

1.png

Option = Monthy Turnover

2.png

Best Regards,

Rico Zhou

 

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

 

View solution in original post

Community Support
Community Support

Hi @ANE2CAbo 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

Hi, @RicoZhou 

 

Sorry, I was on vacation. And yes, my problem is solved, but there's still an issue...

 

My card has two different measures, and the first one is percentage, while the second is an absolute value.

I can't format the measures according to the conditions above.

 

It seems the format replies the card, not the measure.  What can I do, please?

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors