cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sathishramuk33
Frequent Visitor

dax issue

hi everyone ,

i have some dax issues , my requriments is when i click on that currency slicer is filter to the matrix table only first three row is not change in currency values .

so am create one" parameter id" column also like (1,2,3,4,5...)

example:

i need to first three row values is " column =A "values , otherwise fourth to end row values given from " netvalue" measure value.

(var netvalue =axb

if paramter id=1 or 2 or 3

return 'TABLE B'[InputValueInEURO] values

else

return netvalue)

 

am written the dax is:

 

TabularView = var selectedCurrency = IF(ISBLANK(SELECTEDVALUE('table A'[CurrencyCode])), "EUR", SELECTEDVALUE('TABLE A'[CurrencyCode]))
var netValue = (SUMX('TABLE B',
    'TABLE B'[InputValueInEURO] *
    Lookupvalue('TABLE A'[EurRate],
        'TABLE A'[CustCurrencyDate], 'TABLE B'[CustomYearMonth],
        'TABLE A'[CurrencyCode], selectedCurrency)))
return netValue
tempsnip.png

 

pl sort me out

1 REPLY 1
Anonymous
Not applicable

Hello @sathishramuk33 
If you want to change the currency based on the slicer then you can refer to the below links.
Link 1 
Link 2 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors