Measure based on filter which overrules row context matrix

[J4ns3n]

Hi,

Is there a way to create a measure based on a slicer selection which overrules the row context in a matrix?

So I have the following slicer, I created a measure which is based on country level. When I select a country it needs to show de local ledger (this is a different colum). When nothing is selected it needs to show the currency EURO which is a different column in my fact table. 

I created the next measure: 

if(DISTINCTCOUNTNOBLANK('DM_Table'[LedgerCurrencyCode])>1,

SUM(FACTS[CorporateAmount]),if(SELECTEDVALUE(SelectCurrency[SelectCurrency]) = "Euro",

 SUM(FACTS[CorporateAmount]),

 SUM(FACTS[LedgerAmount])))

The problem is now that in my matrix country level is used as a row, this has as an effect that my measure calculates the amount on local ledger level, but when nothing is selected in my slicer I need the measure to calculate NOT the local ledger. Eventually when 1 country is selected I want to see the local ledger. 

@amitchandak 

[J4ns3n · Accepted solution]

Thank you for your help, but the function ALLSELECTED() did the job. 

[yingyinr]

Hi @J4ns3n ,

Could you please mark your post as Answered if your problem has been resolved? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[yingyinr]

Hi @J4ns3n ,

In order to give you a suitable solution quickly, could you please provide some sample data in your tables (exclude sensitive data) with Text format, your matrix Fields settings and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Matrix Fields settings

Best Regards