Measure with customized totals

[Alex-PBIComm]

Good afternoon everyone,

I'll try to be brief as everytime I post this message it goes to spam. Don't hesitate to ask for more info if the request is not clear.
I'd like to create a measure that displays a total calculated differently from the rows. I have a table with the total value of sales in local currencies and through SWITCH + Slicers I allow the user to recalculate the values for all markets converted in dollars.
My goal is, when the "local currency" view is selected, to see each row/market with the local currency but the total always converted in dollars.

Thanks in advance for your help!

[V-lianl-msft]

Hi @Alex-PBIComm ,

If you have a question about something that just isn't working right, post as much information as you can, starting with your data. (Use sample data and remove sensitive data).Please include an example of the visual or the expected results of a calculation in your post.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

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

[Alex-PBIComm]

Hello @V-lianl-msft, as mentioned in my post I've been trying to post this successfully for about a month, ending up in spam all the times. That forced me to put minimal information in order not to have it marked.
Also, as some of my attempts where released from spam section, it caused duplicate posts which I didnt notice (https://community.powerbi.com/t5/Desktop/Measure-with-customized-totals/m-p/2217482#M809865). In the link I was able to provide more information on what's the expected result.

[smpa01]

@Alex-PBIComm  what is the current measure that gives the total?

[Alex-PBIComm]

Switch( TRUE(),

VALUES(Slicers[Conversion]) = "$ Conversion",

Calculate(SUM(Sales[c__SelloutPrice-Converted]),

filter(Sales,Sales[Date]>=date(year(max('Calendar'[Date])),month(max('Calendar'[Date]))-1,day(max('Calendar'[Date])))),

filter(Sales,Sales[Date<=max('Calendar'[Date]))),

VALUES(Slicers[Conversion]) = "Local Currency",

Calculate(SUM(Sales[Amount]),

filter(Sales,Sales[Date]>=date(year(max('Calendar'[Date])),month(max('Calendar'[Date]))-1,day(max('Calendar'[Date])))),

filter(Sales,Sales[Date<=max('Calendar'[Date]))),

Blank())