The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have problem with Currency update in slicer.
Problem statement is: I have data for GBUs like AU,NZ and UI in AUD, NZD and USD and FX currency slicer(AUD,NZD,USD and EURO) how with the help of dax can i dynamically convert it to one selected currency by user?
Attached is the sample PBI.
Hi @Anonymous - in your measure try using
SELECTEDVALUE(Conversion[value])
instead of
MIN(Conversion[Value])
Hope this helps
David
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |