Rank measure help
Hi all, I’m hoping someone can help, as endless hours of searching and battling with co-pilot has proved useless 😞 I have email performance data and I’m simply trying to create a measure that ranks the performance of emails - based on their 'open rate' - within a selected time period. My data / tables are as follows: I have 1 table with email performance metrics / a calendar table / and a table that assigns each date to a category such as “Last month”, “Last 6 months”, “Last 30 days” etc and this is what gets used a slicer. My aim: I’m trying to create a measure that will return the rank of each email, based on its open rate % (i.e. sum of opens / sum of delivered), for the emails that were sent based on the date filter that has been selected e.g. for all emails sent out in the “last 7 days”. The biggest open rate = rank 1. Side note: The same email may be sent multiple times, but the open rate % needs to include all opens related to that email (e.g. if "Email 1" is sent on 2 dates, it is the collective sum of these opens - if those dates fall within the selected time period. Any help, advice or pointers would be massively appreciated !!
Dynamic Ranking for legend.
Hello all, So I have been working on a powerbi project and I am new to this so just exploring. I have orders table, customers table,date table along with few other tables and I have created measures for metrics like Order count, Order quantity, LIFR%,VOFR%,OTIF%, etc. What I want to do is, plot a linechart of every metric with time (from date table) but only top N customers. So I have done this till now. Basically I created a table with metrics name and then Selected_Metric_Value will return the metric value when i select it in slicer. I have tried using RANKX but the lineplot does not show the legend of customer names properly. For eg : If I select LIFR% on the slicer, I want the linechart to have top N customers lines vs timeframe. Then if I select Order count then I want the plot to dynamically change the data and legend both. MetricsTable = DATATABLE( "Metric", STRING, { {"Order Count"}, {"Order Lines Count"}, {"Order Quantity"}, {"LIFR%"}, {"VOFR%"}, {"OTIF%"} } ) Selected_Metric_Value = SWITCH( TRUE(), SELECTEDVALUE(MetricsTable[Metric]) == "Order Count", [Total_orders], SELECTEDVALUE(MetricsTable[Metric]) == "Order Lines Count", [Total_order_lines], SELECTEDVALUE(MetricsTable[Metric]) == "Order Quantity", [Total_order_quantity], SELECTEDVALUE(MetricsTable[Metric]) == "LIFR%", [LIFR%], SELECTEDVALUE(MetricsTable[Metric]) == "VOFR", [VOFR%], SELECTEDVALUE(MetricsTable[Metric]) == "OTIF%", [OTIF%], BLANK() )
