Two layers of measures - 3 measures from 12 columns expressed in 4 currencies

[aw1234]

Hi,

I have a battle to win with PBI (as everyone here I guess). Do I have your axe?

My case is that I have three measures eg. total_sales (value of all sales), mobile_sales (value of puchase made via mobile) and domestic_sales (valeu of purchase made by domestic customers). Those measures derrive from 12 columns since each measure have four columns for each currency needed for reporting (EUR, GBP, USD, PLN). With this in the source table for total sales I have: total_sales_eur, total_sales_gbp etc. tha same goes for mobile sales and domestic sales.

SO.

Is there a possibility to have both "combo" measure that will show eg. sum of sales in selected (with slicer) currecy AND on top of that selector for what measure should be displayed on a chart?

Bonus is that I'll need to calculate also eg. % of mobile sales so sum(mobile_sales)/sum(total_sales) everything ofc remembering about currency and this measure should be also available to be selected amongst other to be presented on the chart.

I was thinking to use param with nameof or switch but got stuck in some very dark alley...

Any ideas?

[Idrissshatila]

Hello @aw1234 ,

field parameters might be a solution for your case. 

check it out here https://youtu.be/nWgPynP9XDM?si=fhXg3ePDL1JnyXQL

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡