Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Measure based on filter which overrules row context matrix

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 

 

DAX
Matrix Visual
Slicer
  • Anonymous's avatar
    Anonymous
    3 years ago

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    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