Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to multiply Split by the Volume on the match of Hopital and Pathway. The added issue I have aswell is the both tables are a many to many relationship on Hospital and Pathway, which I can resolve by creating reference tables and joining both tables to them.
I get results with
Volume Split by Overnight = SUM(Activity[Volume])*SUM(Hospital[Split])
But I get the incorrect total.
Here is the tables;
Relationships to resolve many to many;
Thank you in advance!
Solved! Go to Solution.
Hi @Anonymous,
Based on your steps, please create the measure below to achieve your desired output.
Measure = VAR _table = FILTER ( GENERATE ( Activity, Hostipal ), Activity[Hospital] = Hostipal[Hospital] && Activity[Pathway] = Hostipal[Pathway] ) RETURN SUMX ( _table, [Volume Split by Overnight] )
Here is the output.
Best Regards,
Cherry
Hi @Anonymous,
Based on your steps, please create the measure below to achieve your desired output.
Measure = VAR _table = FILTER ( GENERATE ( Activity, Hostipal ), Activity[Hospital] = Hostipal[Hospital] && Activity[Pathway] = Hostipal[Pathway] ) RETURN SUMX ( _table, [Volume Split by Overnight] )
Here is the output.
Best Regards,
Cherry
Dear Cherry
I have a very similar problem like JayZee64.
Applying your solution I noted that it took a bit of time to calculate the measure with a mid-sized table.
Does the below method also work well with large tables?
Are there alternative options you would recommend besides the _table on the fly?
Many thanks in advance
F.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |