cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
J4ns3n
Frequent Visitor

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 


 

1 ACCEPTED SOLUTION
J4ns3n
Frequent Visitor

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

View solution in original post

3 REPLIES 3
J4ns3n
Frequent Visitor

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

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yingyinr
Community Support
Community Support

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 settingsMatrix Fields settings

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors