Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a page of KPIs for sales by each channel. I have created a dynamic switcher that allows me to switch between total $ amount and percentage of total. However, whenever I try to format these measure it returns blank.
For example:
Switcher = SWITCH([Selected Measure],1,FORMAT([Direct Mail $],"$000,000.00"),2,CALCULATE(SUM([Total Sales]), [channel] = "Direct Mail"))/FORMAT(SUM('[Total Sales]),"0.00%")
Solved! Go to Solution.
Hi @Anonymous,
I tried it like below successfully. You can give it a try.
Switcher = SWITCH ( [Selected Measure], 1, FORMAT ( [Direct Mail $], "$000,000.00" ), 2, FORMAT ( CALCULATE ( SUM ( [Total Sales] ), [channel] = "Direct Mail" ) / SUM ( [Total Sales] ), "0.00%" ) )
Best Regards,
Dale
Hi @Anonymous,
I tried it like below successfully. You can give it a try.
Switcher = SWITCH ( [Selected Measure], 1, FORMAT ( [Direct Mail $], "$000,000.00" ), 2, FORMAT ( CALCULATE ( SUM ( [Total Sales] ), [channel] = "Direct Mail" ) / SUM ( [Total Sales] ), "0.00%" ) )
Best Regards,
Dale
Hi @Anonymous,
I would set your calculations inside the measure using VAR and then just call them in SWITCH.
That still does not work. It seems that using the FORMAT() function is not allowed in a KPI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |