Total are correct of measures

HI ARVINDlsllp,

It sounds like a common measure total level calculation issue that appears when your formula needs to calculate with multiple level aggregations, you can try to use following measure formula if it helps:

formula =
SUMX (
    SUMMARIZE (
        ALLSELECTED ( Append1 ),
        [REGIME],
        "DC_REF",
            IF (
                ISFILTERED ( Append1[REGIME] ),
                CALCULATE (
                    DISTINCTCOUNT ( Append1[REF] ),
                    FILTER ( Append1, Append1[Flag] = "B" )
                )
                    + CALCULATE (
                        DISTINCTCOUNT ( Append1[REF] ),
                        FILTER ( Append1, Append1[Flag] = "C" )
                    ),
                CALCULATE (
                    DISTINCTCOUNT ( Append1[REF] ),
                    SEARCH ( "C*", Append1[REGIME], 1, 0 ),
                    FILTER ( Append1, Append1[Flag] = "B" )
                )
                    + CALCULATE ( DISTINCTCOUNT ( Append1[REF] ), Append1[Flag] = "C" )
            )
    ),
    [DC_REF]
)

In addition, you can also take a look at Greg’s blog to know more about this issue:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

Hello 

let me tell you the total of is not correct, i have exported data into excell the total is different in power bi matrix visual. how c=i can fix this?

No, Its nots working

Hi ARVINDlsllp,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng