Forum Discussion
Combining Multiple Data 'Views' on Single Chart
- 1 year ago
Hi ahiemstra
Yiu need ti calculate 3 different measures with the needed aggregations and "filter manipulations" and put them on the wanted graph.
Something like :There are 3 "independent measures" on the graph.
I attached my pbix with the example
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- Anonymous1 year ago
Hi ahiemstra
Thanks for the reply from Ritaf1983 .
So far I have modified your measure with the following results:
Avg Encounters/Day Discipline = VAR _count1 = CALCULATE(COUNT('1 ON 1'[Encounter Time]), FILTER('1 ON 1', [Activity Description] = SELECTEDVALUE('1 ON 1'[Activity Description]))) VAR _count2 = COUNTX ( SUMMARIZE ( '1 ON 1', '1 ON 1'[Employee ID], '1 ON 1'[Encounter Date] ), '1 ON 1'[Encounter Date]) RETURN DIVIDE(_count1, _count2)Avg Encounters/Day Provider = VAR _count1 = CALCULATE(COUNT('1 ON 1'[Encounter Time]), FILTER('1 ON 1', [Employee Full Name] = SELECTEDVALUE('1 ON 1'[Employee Full Name]))) VAR _count2 = COUNTX ( SUMMARIZE ( '1 ON 1', '1 ON 1'[Employee ID], '1 ON 1'[Encounter Date] ), '1 ON 1'[Encounter Date] ) RETURN DIVIDE(_count1, _count2)Output:
However, I have noticed a problem in that the results are the same for both measures. I'm not sure if this is a result of incomplete example data? Please feel free to let me know if there are any other problems.
Best Regards,
Yulia XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ahiemstra
Thanks for the reply from Ritaf1983 .
So far I have modified your measure with the following results:
Avg Encounters/Day Discipline =
VAR _count1 = CALCULATE(COUNT('1 ON 1'[Encounter Time]), FILTER('1 ON 1', [Activity Description] = SELECTEDVALUE('1 ON 1'[Activity Description])))
VAR _count2 = COUNTX ( SUMMARIZE ( '1 ON 1', '1 ON 1'[Employee ID], '1 ON 1'[Encounter Date] ), '1 ON 1'[Encounter Date])
RETURN
DIVIDE(_count1, _count2)
Avg Encounters/Day Provider =
VAR _count1 = CALCULATE(COUNT('1 ON 1'[Encounter Time]), FILTER('1 ON 1', [Employee Full Name] = SELECTEDVALUE('1 ON 1'[Employee Full Name])))
VAR _count2 = COUNTX (
SUMMARIZE ( '1 ON 1', '1 ON 1'[Employee ID], '1 ON 1'[Encounter Date] ),
'1 ON 1'[Encounter Date]
)
RETURN
DIVIDE(_count1, _count2)
Output:
However, I have noticed a problem in that the results are the same for both measures. I'm not sure if this is a result of incomplete example data? Please feel free to let me know if there are any other problems.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.