Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a requirement to show Sales for 10 Stores in US$ ( I have data both in US$ and CA$ for these 10 Stores) in a table, But when the data drills up, it needs to show in CA$. Alternatively, Can I show the data by Store by Product in US$ and the TOTAL in CA$? Is this possible in Power BI?
Thanks In Advance.
Tutan
Solved! Go to Solution.
You may add IF Function to a measure and use HASONEVALUE Function to detect the drill down level.
You may add IF Function to a measure and use HASONEVALUE Function to detect the drill down level.
For example: I have 10 Stores which has Sales $ info both in US$ and CA$. I want to show the non aggregated data for Sales by product for these 10 Stores in US$ and I want a TOTAL line in the same table which will show the aggregated number in CA$. Is this possible in Power BI? Please help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |