-
Dynamic (Contextual) Annotations
Annotations are extremely useful as a visual cue on cards to explain why calculations may differ on or following an event. Currently these annotations are generalized to the dataset/date. Annotations could be further expanded to be row-level contextual, only visible when filter conditions are met. Suppose Store A is…
-
I'm stuck. Sum of a Windowed/Partitioned Sum???
I keep running into a wall with this. I think there is an easy answer, I just can't find it for the life of me. My dataset contains one row per store, per day. I want to display -- by region -- the count of stores with an average order value (AOV) less than $20. In order to do that, I first need to calculate AOV by store…
-
Filtering Rows without Displaying Them / Same-Store Comparison
I have a dataset of sales data with one record per store, per day, across multiple years. I used @jaeW_at_Onyx's offset date table solution to get YOY and POP comparisons; but I'm not positive that's relevant to my [hopefully simple] question. I'm trying to create a filter for same-store comparisons. I am defining…
-
% Sold of Available Inventory (aka Sell-Through)
I am stumped on this one. I have two tables: an orders table and an inventory table. orders contains a record for each order placed by a customer; and inventory holds a record of how much inventory is available at the start of the period. Note that qtyAvail does not update... it is a reflection of how much that store…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
FIXED Function - Static Filters
FILTER ALLOW/DENY is the most useful piece of FIXED for me. What would juice up its usefulness to the next level is an ability to use static filters in the function. For example - SUM(SUM(`totalSales`) FIXED (FILTER `Client`='ABC Company')) Beyond simply allowing or denying field filters to affect the calculation, you…