Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have two data sets of encounter goals (set1 and set2) for physician practices. A Practice table is joined to both data sets.
I need a measure to calculate the encounter goals + targets depending on which practices are selected in a multi-select slicer - note that multiple practices must be selectable, and they need to be selectable from one or both datasets.
Practices in set1 are an updated subset of what is in set2. I.E. So even though PracticeA exists in both datasets, it must only use the Provider Goals measure. So that if we were to sum everything, the total would be 50+60+70+25+10+15 = 230
Selectable items from set1 must use the [Provider Goals] measure.
Selectable items from set2 (and not in set1) must use the [Provider Targets] measure.
Below is what I have attempted, but it does not work when multiple items are selected from the Practice Slicer.
Solved! Go to Solution.
Hi,
As I understand Set 2 is the superset, hence I have created a separate dimension table for Practice from Set2 in Power Query.
let
Source = Set2,
#"Removed Other Columns" = Table.SelectColumns(Source,{"Practice"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
#"Removed Duplicates"
Then I joined that with both the Set1 & Set2 tables.
After that I created the below measure:
When partial selected:
Hope this helps.
If this help to resolve your problem, then please mark it as solution, Thanks!
Hi,
As I understand Set 2 is the superset, hence I have created a separate dimension table for Practice from Set2 in Power Query.
let
Source = Set2,
#"Removed Other Columns" = Table.SelectColumns(Source,{"Practice"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Other Columns")
in
#"Removed Duplicates"
Then I joined that with both the Set1 & Set2 tables.
After that I created the below measure:
When partial selected:
Hope this helps.
If this help to resolve your problem, then please mark it as solution, Thanks!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |