dax issue

[sathishramuk33]

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

 

pl sort me out

[Anonymous]

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