Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Dear All,
What I am trying to achieve:
Calculate Min, Max, and AVG gross profit % for 'Product Category', whilst ignoring the slicer selection of 'Product'.
So, when I select a 'Product' (e.g. Galaxy S20) in the slicer selection, I don't want my Min/Max/AVG gross margin % measures to show values only for 'Galaxy S20' (i.e. 'Product'), but instead I want to see Min/Max/AVG for the entire 'Product Category' (e.g. 'Smartphones').
In other words, at the end of the day, I want to compare 'Product' gross margin % with the entire 'Product Category' gross margin %.
Any tips appreciated! I have tried a few measures so far to no avail, but I will continue trying new things out!
Thank you all!
Solved! Go to Solution.
Hi @Giorgi1989
try something like
CALCULATE ( [measure], REMOVEFILTERS ( 'Product' ), VALUES ( 'Product'[Category] ) )
Hi @Giorgi1989
try something like
CALCULATE ( [measure], REMOVEFILTERS ( 'Product' ), VALUES ( 'Product'[Category] ) )
Thank you so much! This works like a charm! Thank you!!!
User | Count |
---|---|
18 | |
18 | |
14 | |
14 | |
13 |
User | Count |
---|---|
17 | |
14 | |
11 | |
10 | |
8 |