Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 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.
I attempted multiple measures to get the results i need. I can do either SUM or AVERAGE but not both. Where am i going wrong?
Solved! Go to Solution.
Hi @ybicalways79
Please try
FormatMetric OperationalSales =
VAR Val =
SUM ( SalesData[Value] )
VAR Ave =
AVERAGE ( SalesData[Value] )
RETURN
SWITCH (
SELECTEDVALUE ( SalesData[Attribute] ),
"Overall Sales", FORMAT ( Val, "$#,##0;($#,##0)" ),
"Overall Conversion (%)", FORMAT ( Ave, "0.0%" ),
"Overall Margin (%)", FORMAT ( Ave, "0.0%" ),
"Overall Lookup (Ct.)", FORMAT ( Val, "0" )
)
Hi @ybicalways79
Please try
FormatMetric OperationalSales =
VAR Val =
SUM ( SalesData[Value] )
VAR Ave =
AVERAGE ( SalesData[Value] )
RETURN
SWITCH (
SELECTEDVALUE ( SalesData[Attribute] ),
"Overall Sales", FORMAT ( Val, "$#,##0;($#,##0)" ),
"Overall Conversion (%)", FORMAT ( Ave, "0.0%" ),
"Overall Margin (%)", FORMAT ( Ave, "0.0%" ),
"Overall Lookup (Ct.)", FORMAT ( Val, "0" )
)
Thank you! I was so close on this one!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
32 | |
25 | |
16 | |
14 | |
13 |