Forum Discussion
tiagopardo
2 years agoFrequent Visitor
Comparison page layout
Hi, I'm builting a platform in wich one of the pages will have one scatterplot. The platform has one filter visual for company selection, and the filter syncs along the report pages. With...
- Anonymous2 years ago
Hi tiagopardo ,
I'm not sure if I'm understanding you correctly.
Here is my sample dataset:I create table(2) and table(3) to create two slicers:
No relationship exists between the three tables:
Use this DAX to create a measure:
Measure = IF( SELECTEDVALUE('Table'[Company]) = SELECTEDVALUE('Table (2)'[Company]) || SELECTEDVALUE('Table'[Company]) = SELECTEDVALUE('Table (3)'[Company]), 1, 0 )Suppose I want to compare firm a and firm b:
I'm not quite sure why you're talking about the phrase "because the original may only get one company at a time". Because both Filter and Slicer support multi-selection.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tiagopardo
2 years agoFrequent Visitor
Thank you for your support. That's what I needed.