medium10 pts · first answer countsdata-visualizationdax

Share of total for each product

You want each product's share of total sales in a table with Product on rows, while still respecting a Year slicer. Which denominator is right?

A.CALCULATE([Sales], REMOVEFILTERS(Product))B.CALCULATE([Sales], REMOVEFILTERS())C.[Sales] for the current rowD.SUM(Sales[Amount]) with no CALCULATE

Discussion 0

Join free to post in the discussion.