Forum Discussion
sathishramuk33
5 years agoFrequent 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
pl sort me out
1 Reply
- AnonymousNot 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