Forum Discussion

abhifx's avatar
abhifx
Frequent Visitor
2 years ago

Unable to Replace Column data in Matrix Using Switch

Dear All   I have been trying to replicate the revenue statement in Power BI directly linked with a trial balance. However once i insert a format and link multi level data into Power BI, I am unabl...
Need Help
abhifx's avatar
abhifx
Frequent Visitor
2 years ago

hi danextian , sorry for delayed reply. Getting in to quarterly review meetings.

 

So about the switch function, i am now able to get sub totals as per desired format, however, when the report is drilled down then total is lost. how to fix that?

 

below the witch function

Switch Subtotal = 

SWITCH(
    SELECTEDVALUE('MIS Format'[Line Item Desc]),
    "Total Sale",[Total Sales], 
    "Total Variable Cost",[Total Variable Cost],
    "Total COGS Without VC",[Total COGS Without VC],
    "Total COGS", [Total COGS],
    "Gross Profit",[Gross Profit],
    [Total Trial]

)