Hi, could someone help me find the way to calculate the percentage of sales for each product category, where 100% represents different countries?
Thanks!
Something like this might work for you.
% OF Country Sales =
var _countrySales =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Country])
)
Return
DIVIDE(
SUM('Table'[Value]),
_countrySales,
0
)You can replace the 'Table' with your table name and the SUM('Table'[Value]) with the table/column from your table.
Proud to be a Super User! |  |
Something like this might work for you.
% OF Country Sales =
var _countrySales =
CALCULATE(
SUM('Table'[Value]),
ALLEXCEPT('Table', 'Table'[Country])
)
Return
DIVIDE(
SUM('Table'[Value]),
_countrySales,
0
)You can replace the 'Table' with your table name and the SUM('Table'[Value]) with the table/column from your table.
Proud to be a Super User! | |
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
