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.
Hello!
These are my columns, currently the values in this columns are Currency data type (BRL) Brazil actual currency.
'Budget Engineer'[Budget EST 2 Acumulado]
'Budget Engineer'[Budget 2019 Monthly]
'Budget Engineer'[Budget 2019 Acumulado]
'Budget Engineer'[Budget EST 2 Monthly]
I have another table 'Currency' without any table connections, with:
I need to when one of those flags is selected (i already have the currency rate of the selected currency in a calculated measure) the values on the 4 columns in 'Budget Engineer' change.
Also the 'Currency' is represented in my dashboard as:
Solved! Go to Solution.
Hello and thanks for the quick response, but I already kill this problem with this:
__Total Budget EST2 Monthly = IF(COUNTROWS(DISTINCT(ALLSELECTED('Currency'[Flag]))) < COUNTROWS(DISTINCT(ALL('Currency'[Flag])));SWITCH(TRUE(); [Selected currency]="EUR"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"€ 0,00"); [Selected currency]="USD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"U$ 0,00"); [Selected currency]="DKK"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 kr"); [Selected currency]="BRL"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"R$ 0,00"); [Selected currency]="CAD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"C$ 0,00"); [Selected currency]="CHF"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 fr"); [Selected currency]="GBP"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"£ 0,00"); [Selected currency]="AUD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"A$ 0,00"); FORMAT([_Total Budget 2019M];"R$ 0,00"));FORMAT([_Total Budget EST2M];"R$ 0,00"))
Hi @marcura ,
If I understand your requirement correctly, do you want to show the four columns based on the selected Currency?
For example, if you select DKK, the Budget Engineer'[Budget EST 2 Acumulado] should show the value as [Budget EST 2 Acumulado]*0.6058?
If so, I think you could create four measures like below to achieve that. You could modify it based on your scenario.
Measure = CALCULATE ( MAX ( 'Table'[Column1] ) * SELECTEDVALUE ( 'Table 2'[rate] ), FILTER ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Currency] = SELECTEDVALUE ( 'Table 2'[Currency] ) ) )
Here is my test output.
If you still need help, please share your data sample as table format and your desired output so that we could help further on it.
Best Regards,
Cherry
Hello and thanks for the quick response, but I already kill this problem with this:
__Total Budget EST2 Monthly = IF(COUNTROWS(DISTINCT(ALLSELECTED('Currency'[Flag]))) < COUNTROWS(DISTINCT(ALL('Currency'[Flag])));SWITCH(TRUE(); [Selected currency]="EUR"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"€ 0,00"); [Selected currency]="USD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"U$ 0,00"); [Selected currency]="DKK"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 kr"); [Selected currency]="BRL"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"R$ 0,00"); [Selected currency]="CAD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"C$ 0,00"); [Selected currency]="CHF"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"0,00 fr"); [Selected currency]="GBP"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"£ 0,00"); [Selected currency]="AUD"; FORMAT([_Total Budget EST2M]/VALUES('Currency'[Currency Rate]);"A$ 0,00"); FORMAT([_Total Budget 2019M];"R$ 0,00"));FORMAT([_Total Budget EST2M];"R$ 0,00"))
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |