hard20 pts · first answer countsexcelpower-pivotdax

Total Sales that follows slicers

In the Excel Data Model, you need "Total Sales" that adjusts to whatever slicers and pivot rows are selected. Should it be a measure or a calculated column?

A.A measure, calculated at query time for the current filtersB.A calculated column, stored once for each row at every refreshC.A calculated column, since measures cannot use SUMD.Either one, as both behave the same in pivots

Discussion 0

Join free to post in the discussion.

Total Sales that follows slicers

Discussion 0

Related questions