Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

USERELATIONSHIP 2 measures on line graph

I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph:

 

 

However I've tried to create a userelationship measure to get them on to the correct axis and I'm getting the correct numbers for Epi Count but  Event count values are coming in as counts rather than the ones I need (highlighted  on left below):

 

I'm using this measure:

Cumulative Rate - Event Count = CALCULATE(COUNTX('Sheet1',[Prev 14 Day Event Count]/4761865*100000),USERELATIONSHIP(Sheet1[Event Date],DimDate[Dates]),NOT(ISBLANK('DimDate'[Dates])))

 

Can anyone help get the Cumulative rate -Event counts on to the line graph

 

SEE FILE ATTACHED

https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Sorry for my late reply.

     

    I'm a little cofused about your calculation logic. What is the calculation logic of Cumulative Rate-Event Count and Cumulative Rate-Epi Count?

     

    The data in the attachment I downloaded is different from the picture you provided.

     

     

     

    Best Regards,

    Stephen Tao

     

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