Forum Discussion

tsunamisabella's avatar
tsunamisabella
Frequent Visitor
3 years ago
Solved

Create a dynamic column subtotal measure

Hello! I want create a measure [Subtotal] to retrieve the column subtotal (subtotal of the selected period) which can be dyanically changed along the selected column dimension [Period]. Note that [Pe...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi tsunamisabella 

    Please try

    Subtotal =
CALCULATE ( [a_measure], ALLSELECTED ( table_name[Period] ) )
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi tsunamisabella 

Please try

Subtotal =
CALCULATE ( [a_measure], ALLSELECTED ( table_name[Period] ) )
  • tsunamisabella's avatar
    tsunamisabella
    Frequent Visitor
    3 years ago

    OMG! Thank you for the swift reply and the simply & wonderful solution 🥰!