Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have a matrix that shows breakdown of events and countries that looks something like this:
Country | Event 10803 | Event 14333 |
Italy | 6 | 8 |
UK | 43 | 32 |
US | 51 | 54 |
I want to add a column to the end of this that calculates the growth rate between these events, however, the way this report works is that a slicer will be used to select which events are displayed, so the measure cannot just be "Event 10803" - "Event 14333" because there are tons of event combinations that could be selected. What's more I want the growth rate to be based on event timing (this field is on the same object as the events), so the most recent event always gets placed as the first number. I calculated a similar measure (taking into account dynamically selected events, event date and revenue) by using the following code:
Event Revenue Growth = VAR SelectedCampaigns = VALUES ( Event[Start Date] ) VAR OldEvent = CALCULATE ( [Event Revenue (£)], FIRSTDATE( SelectedCampaigns ) ) VAR RecentEvent = CALCULATE ( [Event Revenue (£)], LASTDATE( SelectedCampaigns ) ) VAR Difference = RecentEvent - OldEvent RETURN DIVIDE ( Difference, OldEvent, 0)
This only works as a card however, as when I drag it into a table it shows 0% (because firstdate and lastdate pull out the same event when applied to a table with event as a column/row). Not sure if this code will help as it's a slightly different scenario but I thought it may prompt some ideas.
Any help would be great - thanks
Is that the source data? Example source data would be helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |