Calculate drop % between clustered column bars

[gustavo80]

Hi!

I have a clustered column bar chart like this:

I need to calculate the drop % between second and third event ( in orange and blue, screenViewed and appLaunched) respect to the first event ( light blue, SDKStarted ) for EVERY day.

I created a measure like following, but it didn't work because it sums all values for all days, so I have the same drop % for all days, and I need that this were calculated for any day. I guess I need the following measure keep the day restriction, but I dont know how to indicate it to powerbi.

drop % = CALCULATE( DIVIDE ( SUM('esk_landing init_funnel_events'[appLaunched] ) , SUM('esk_landing init_funnel_events'[sdkStarted] ) ) )

What am I doing wrong ?

Thanks in advance,

Regards

[parry2k]

@gustavo80 if you use % drop measure on the visual, what happens? Logically it should work.

[gustavo80]

Hi @parry2k 

I was expecting that it should work, but i'm getting the same drop% for all days :S ( I change the visualization to clustered and lines just to show the drop% thats is very small compared to totals, but its the same problem in clustered bar chart )

[parry2k · Accepted solution]

@gustavo80 hmmm, seems like something to do with how you are model is structured, can you share sample data?

[gustavo80]

You are absolutely right. Preparing a dummy dataset for you, I realized that there was a problem in my model, thats why it didn't work.

Thanks for your time, it helps me a lot,

Regards!