need help

[anithaMallam]

Hi All,

          i need your help on one of the issue which iam facing.

i have created a measure for exchange rate and which i have placed on score card to display the data. i have currency code which has different curency list in one slicer and region in other slicer.when iam selecting  the currency code from one slicer to see the different exchange rate values in score card it is filtering the region as well which i dont want.Currency code should not filter the region.Could someone please help me in this.

Regards

Anitha.

[v-eqin-msft]

Hi @anithaMallam 

Sorry to disturb you again...

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business. 

Thank you.😀

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @anithaMallam ,

As @amitchandak said, you could set interaction as "none" like this:

Or you could create a new table for slicer (do not build relationship between two tables):

forSlicer =
DISTINCT ( ALLSELECTED ( 'Table'[Currency code] ) )

then use the following formula to match the selected value:

Measure =
CALCULATE (
    MAX ( 'Table'[Rate] ),
    FILTER (
        'Table',
        'Table'[Currency code] = SELECTEDVALUE ( forSlicer[Currency code] )
    )
)

  

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[amitchandak]

@anithaMallam , You can stop interaction between currency and Region slicers.

refer https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions