Forum Discussion

ARVINDlsllp's avatar
ARVINDlsllp
Frequent Visitor
2 years ago

Total are correct of measures

Hello Everyone, Can you please help with my measure i.e.  IF(ISFILTERED(Append1[REGIME]), CALCULATE(DISTINCTCOUNT(Append1[REF]),FILTER(Append1,Append1[Flag]="B")) +CALCULATE(DISTINCTCOUNT(Append...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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