topic Re: Total are correct of measures in Developer

Total are correct of measures

ARVINDlsllp — Tue, 05 Mar 2024 12:43:41 GMT

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(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"))

totals are not correct but while export in excel of the visual values total different from powerbi visual total.

powerbicomm

Re: Total are correct of measures

Anonymous — Wed, 06 Mar 2024 01:37:14 GMT

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

Re: Total are correct of measures

ARVINDlsllp — Thu, 07 Mar 2024 05:49:49 GMT

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?

Re: Total are correct of measures

ARVINDlsllp — Mon, 11 Mar 2024 12:53:30 GMT

No, Its nots working

Re: Total are correct of measures

Anonymous — Tue, 12 Mar 2024 07:37:30 GMT

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

Re: Total are correct of measures

ARVINDlsllp — Tue, 12 Mar 2024 07:51:52 GMT

I can't , its size is too large , I have also filtered top 20 with a column reference but some place above DAX is working fine