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
TarunSharma
Responsive Resident
Responsive Resident

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 User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors