Non Aggregated Value in US$ and aggregated value in CA$ in the same table

[tutan4uall]

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

[v-chuncz-msft · Accepted solution]

@tutan4uall,

You may add IF Function to a measure and use HASONEVALUE Function to detect the drill down level.

[tutan4uall]

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.