Forum Discussion
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?
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
2 Replies
- amitchandakSuper User
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
- JulioSTJFrequent Visitor
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.