Forum Discussion
DAX Questions
Question 1: consol Amount = VAR SelectedCurrency = SWITCH( TRUE(), SELECTEDVALUE(Revenue[Location]) = "Group" || ISBLANK(SELECTEDVALUE(Revenue[Location])), "USD", ...
Thank you.
Q1 solved.
Q2 supposed based on Q1+Year 2024 only = Top 5 list.
their trend suppose shown from 2020-2024
Q3. May I ask what is a dummy data? I have 4 categories in Year 2024, and they share the same amount of line y-axis based on location.
For eg, Group is 40%, Hong Kong is 27%, Shanghai ... Singapore ...But they are not different by the y-axis categories
Can you clarify more your questions regarding Q2 and Q3? if possible can you share some data please?