Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Team,
It will be much appreciated if anyone can help me in deriving a logic to calculate the overall Average against each customer by excluding the current line supplier.
Example:
The Dax should automatically eliminate the current line's Supplier and should calculate the average for the rest of the Suppliers.
Supplier | Sales | Comparative Average |
A | 3 | Average(b&C) |
B | 5 | Average(A&C) |
C | 4 | Average(B&C) |
Any suggestion will help in my analysis to calculate the benchmarking against each other.
Thanks so much for your time,
Kind Regards
Sha
Solved! Go to Solution.
Hi,
I think you need that one:
Comparative Average =
CALCULATE(
AVERAGE('Sample'[Sales]);
FILTER(
ALLSELECTED('Sample');
NOT('Sample'[Supplier] in VALUES('Sample'[Supplier])))
)
Basic measures:
Proud to be a Super User!
Hi,
I think you need that one:
Comparative Average =
CALCULATE(
AVERAGE('Sample'[Sales]);
FILTER(
ALLSELECTED('Sample');
NOT('Sample'[Supplier] in VALUES('Sample'[Supplier])))
)
Basic measures:
Proud to be a Super User!
Hi Bolfri,
Thanks for the Idea, It worked Exactly the way I wanted. Much appreciated.
kind Regards
Sha
Step 1
Thanks, Ritesh, for your suggestion.
Much appreciated.
Kind Regards
Sha
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
79 | |
54 | |
39 | |
35 |
User | Count |
---|---|
102 | |
82 | |
48 | |
48 | |
48 |