Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
7 | |
6 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |