Forum Discussion

JulioSTJ's avatar
JulioSTJ
Frequent Visitor
6 years ago
Solved

Multiple filters with the same column

Hello,

 

Can someone help with an idea?

 

I made this simple model with dUser and dCompany related by IDCompany.

 

dUser      dCompany

 

I made 2 measures that just multiply the Value column of dUser by the value on the 2 parameters created:

SUM(dUser[Value])*[Parameter 1 Value]
and
SUM(dUser[Value])*[Parameter 1 Value]

 

Then I made these 2 slicers of IDUsers and set them not to filter each other, so I can have the group of Users with the values using Parameter 1 and another using Parameter 2. But both are filtered by the IDCompany slicer above, but thats ok.

 

What I need to do is to add the totals of the 2 tables (1100 + 4250) and display it in a card with another measure, but once I filter diferent User ID's on each slicer, the sum of both tables just show blank.

 

The original model is way bigger than this, so I made this simplified version.

 

I would like to use only one table as well, but want it to show only the selected ID's of bothe slicers. Is it possible?

 

2 Replies