Need help in correcting Inverse Sum calculations

Hey Anonymous ,

this measure is probably providing what you are looking for:

Measure = 
var _theotherplatforms = 
        EXCEPT(
            CALCULATETABLE(
                VALUES('Query1'[Platform])
                , ALL(Query1[Scenarion Name])
                , ALL(Query1[Platform])
            )
            , CALCULATETABLE(
                VALUES('Query1'[Platform])
                , ALL(Query1[Platform])
            )
        )

return
SUMX(
    ADDCOLUMNS(
        _theotherplatforms
        , "v" , 
            var _p = [Platform]
            return
            CALCULATE(SUM('Query1'[Historical Cases]), ALL(Query1[Scenarion Name]) , 'Query1'[Platform] = _p)
    )
    , [v]
)

At least the table visual looks similar:

Regards,

Tom

P.S.: If this does not tackle your challenge, create a pbix that contains sample data, the filters etc, and explain in great detail why you expect the result. Upload the pbix to onedrive or dropbox and share the link. If you use an xlsx to create the sample data upload the xlsx as well. Personally i will just download sample files from onedrive or dropbox.