TWO MEASURES AT THE SAME CARD ACCORDING TO THE FILTER SELECTED

[Anonymous]

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.

[v-rzhou-msft]

Hi @Anonymous 

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

[Anonymous]

Hi, @v-rzhou-msft 

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?

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

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

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

Option = Monthy Turnover

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. 

[amitchandak]

@Anonymous , seem like a case of measure slicer

refer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115