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 2 tables- hierarchy_SA and historical_accuracy and modeled through 1: many relationship with a column called Service_area. I created some measures in the historical_accuracy table and they work fine when I use the Service_area column thru the same table (historical_accuracy). But when I use the Service_area column from the hierarchy_SA table, the measures break and give me incorrect results. Any ideas?
hello @ishanjain ,
try creating a measure for this:
Measure =
CALCULATE (
SUM(historical_accuracy[Historical_Accuracy_Score]),
historical_accuracy[SERVICE_AREA] IN VALUES ( hierarchy_SA[SERVICE_AREA] )
)
and sum can be exchanged by max or min or whatever expression you want
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |