Forum Discussion
sirbaklava
2 years agoRegular Visitor
Comparing Data Across Two Filters in Power BI
Hello Power BI Community, I'm working on a project where I need to compare data across two different filters at a time. My dataset includes two key columns: Site and Item Name. The goal is to cre...
- 2 years ago
How about this table?
I also set the filter.
When using the 'SELECTEDVALUE' function, I think the data column you set for the slicer should be different from the base data column.
sirbaklava
2 years agoRegular Visitor
Micky thank you so much for replying to my topic.
I see that you created 2 new tables using summarize. I'm having trouble understanding how to apply this to my exact issue. Picture shown below as to what I'm really looking for:
my goal is to have the tables show the items within each site. and then a measure just saying if the item is included in the other selected comparison site.
mickey64
2 years agoSuper User
How about this table?
I also set the filter.
When using the 'SELECTEDVALUE' function, I think the data column you set for the slicer should be different from the base data column.