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.
Please help me to solve
Hi:
Please see link for the figures (they are in either "Result Table" or Sum Table".) I hope this is what you are looking for. My average is higher than yours $2.85 v $2.24...
https://drive.google.com/file/d/14fcOeKrRrKhdClu7gIcyra7F4Rdx4d9W/view?usp=sharing
hi @sriramk
1. IF ( MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] ), "Above Avg", "Below Avg" )
2. MAX ( Table1[Revenue/Cost] ) >= [Average Rev/Cost] )
then use the measure in the conditional formatting >= 1 for green and 0 for red
3. DIVIDE ( MAX ( Table1[Revenue/Cost] ) - [Average Rev/Cost] , [Average Rev/Cost] )
4. Please clarify further
Hi, Thank you very much for the details.
Clarification for S.No.4 :
If the deviation from Average is more than 3%, to show the product name and store ID in the report on selected date.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |