Multiple filters with the same column

[JulioSTJ]

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?

[amitchandak · Accepted solution]

@JulioSTJ , for this case you need slicer for IDuser ID. If you want to sum up two scenarios. You can sum up the same value of IDUSER with parameter 1 and parameter2 .

Just like this, where I have taken 2 date slicer from the different dimensions

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[JulioSTJ]

It worked, @amitchandak .

I've made a few adjustments for what I need, created a few tables with the ID's and it worked.

Thank you.