Calculate the difference between the count of 2 GA4 events on an area chart

[smoorthy]

Hi,

I have a stacked area chart that shows the usage trends of two GA4 events with their event count for the past 12 months, with count as Y axis and year-month as x axis. These two events are on the legend. Now I want another parameter(new event) on the graph which is basically the subtraction of these two specfic GA4event counts. I thought this should be as simple as New value = GA4eventcount1 - GA4eventcount2, but when I try the visual calculation it is not as simple. When I try to enter the formula for calculation it doesn't let me select the specific event name counts to subtract. Not sure how to get this new value.

Any help/suggestion is welcome appreciated.

Thank you

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...