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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Unify Report Currency Based On the Slicer; on aggregated/grouped data and comb. data with other data

Hi,

 

1)I found a useful query in a former post which i used to calculate currencies based on a slicer (See below), however when i want to group for example the sales of customers to two different categories such as new customers and exisiting customers it does not work; it only wants to show data for each line in the data set and not on an aggregated group level. Any idea how to solve this?

 

2) When i have used this function for 2 tables (it works on each table separately) and i want to show for example budget data vs the sales data and i try to combine the outcome in one/same table it does not work even though i established a relationship between the tables. Can this be solved wiht crossjoin or something, but still having the currency slicer option query behind?

 

Thanks a lot for help

 

plicable Exchange Rate =
CALCULATE (
    VALUES ( Table1[Ex Rate] ),
    FILTER (
        ALLEXCEPT ( Table1, Table1[Foreign Currency] ),
        Table1[Base Currency] = SELECTEDVALUE ( Table2[Base Currency] )
            && Table1[Month] = SELECTEDVALUE ( Table2[Month] )
            && Table1[YEAR] = SELECTEDVALUE ( Table2[YEAR] )
    )
)

Then Revenue in the selected Currency is simply

 

Revenue in Selected Currency =
[Applicable Exchange Rate] * SELECTEDVALUE ( Table2[Revenue] ) )  

 

1 REPLY 1
v-cherch-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous 

Sample data and expected output will be helpful to provide an accurate solution.If you need further help,please follow the How to Get Your Question Answered Quickly to post some simplified assumed data and expected output.It would be better if you can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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