Forum Discussion

RENJITH_R_S's avatar
RENJITH_R_S
Icon for Resolver II rankResolver II
3 years ago

Sub total for an entry in Matrix Visual

Hi Friends,

Can you help on my requirent, I need a sub total for a category (demand only) for each areas only please see the example

Also please not the calculation for values in the martrix is defined as

Value =
SWITCH(
    SELECTEDVALUE('Table'[Category]),
    "Budget", [Measure Budget],
    "Remaining Budget", [Measure Remaining Budget],
    "Demand",[Measure Demand],
      BLANK()
    )


Need Help

1 Reply

  • bhelou's avatar
    bhelou
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    hi , can you share a test PBIX file ? will try to solve it