Forum Discussion

nickc_innova's avatar
nickc_innova
Advocate I
3 years ago
Solved

Contexual Subtotal

Looking to have a measure return a sum that retains the context of a slicer but ignores the context of the row on a table visual.  Here is a simple example table of data: Here is a simple t...
Need Help
  • nickc_innova's avatar
    nickc_innova
    3 years ago

    Nevermind, 
    Solved it myself with the following code:

    DynamicSubtotal =
    SUMX(
    CALCULATETABLE('Fact Table', ALLSELECTED('Fact Table'[Category])),
    ('Fact Table'[Values])
    )
nickc_innova's avatar
nickc_innova
Advocate I
3 years ago

Nevermind, 
Solved it myself with the following code:

DynamicSubtotal =
SUMX(
CALCULATETABLE('Fact Table', ALLSELECTED('Fact Table'[Category])),
('Fact Table'[Values])
)