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.
Hi All,
I am facing an issue with the measure that needs to be calculated at group level (grouping as in SQL).
I have a measure called [Total Number of visits for Serving Unit with both WS and WS MH] which needs to be calculated depending upon below conditions :
1. Within the Group of Proportion Class and Serving Unit, if the Funding Purpose is equal to WS MH then :
[Total Number of visits for Serving Unit with both WS and WS MH] = Number of Attended Appointments[against that Prop.Class, Serving Unit, Funding Purpose = 'WS' + Number of Attended Appointments[against that Prop.Class, Serving Unit, Funding Purpose = 'WS MH'
Number of Attended Appointments is another measure that is calculated as :
Number of Attended Appointments := CALCULATE ( DISTINCTCOUNT(Tbl1[VisitKey],'Attendance Status'[Attendance Status Code] IN { "5", "6", "9", "VPCP", "VPCPC", "13" })
Serving Unit comes from Tbl2 that is related to Tbl1
Funding Type comes from Tbl3, that is related to Tbl1
2. Wherever the Proportion Class, Serving Unit group does not have a funding type of WS MH then [Total Number of visits for Serving Unit with both WS and WS MH] can be blank or equal to Number of Attended Appointments[against that Prop.Class, Serving Unit, Funding Purpose].
I am not concerned about the second scenario but how to get the values for first scenario ?
How to return a single SUMMED up value for particular grouping at Proportion Class, Serving Unit level.
I am attaching the excel snapshot showing how this needs to be calculated for clarity. Would much appreciate help on this.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |