How can I make calculations in a visual table for Income Statement/ P&L

Hi,

Please share your sample pbix file's link, and then I can try to look into it.

Thanks.

Hi,

I am a bit confused about the logic, but please check the below picture and the attached pbix file.

I hope you can try to amend the formula if I misunderstood the logic.

expected result measure: =
VAR _revenue =
    CALCULATE (
        [Total Actuals],
        'Account Mapping'[Row Index] = 1,
        REMOVEFILTERS ( IsStructure )
    )
VAR _cost =
    CALCULATE (
        [Total Actuals],
        'Account Mapping'[Row Index] = 2,
        REMOVEFILTERS ( IsStructure )
    )
VAR _grossprofit = _revenue + _cost
VAR _gpmargin =
    DIVIDE ( _grossprofit, _revenue )
VAR _otherincome =
    CALCULATE (
        [Total Actuals],
        'Account Mapping'[Row Index] = 6,
        REMOVEFILTERS ( IsStructure )
    )
VAR _sga =
    CALCULATE (
        [Total Actuals],
        'Account Mapping'[Row Index] = 5,
        REMOVEFILTERS ( IsStructure )
    )
VAR _ebitda = _grossprofit + _otherincome - _sga
RETURN
    SWITCH (
        SELECTEDVALUE ( IsStructure[Row Index] ),
        3, _grossprofit,
        4, FORMAT ( _gpmargin, "#.00%" ),
        7, _ebitda,
        [Total Actuals]
    )