Forum Discussion

sathishramuk33's avatar
sathishramuk33
Frequent Visitor
5 years ago

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

 

pl sort me out

1 Reply