Forum Discussion

ahiemstra's avatar
ahiemstra
Helper I
1 year ago
Solved

Combining Multiple Data 'Views' on Single Chart

Hello,   I have an idea and I’m wondering whether it is possible in Power BI.   I have a dataset which I have used to create several different reports. The reports mainly display column charts wi...
  • Ritaf1983's avatar
    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.

     



  • Anonymous's avatar
    Anonymous
    1 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 Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.