Table Sum is not correct

[xiumi_hou]

Dear all, I create a table, but the total on the last line seems not correct, any idea? Thanks!

[az38]

 @xiumi_hou  hi

i think you use aggregation

pick column Current in Vusuals pane and set Do not summarize

[xiumi_hou]

Hi @az38 Thanks for reply.

I just checked my panel, and it shows not aggregation.

[az38]

@xiumi_hou 

what is Current? is it field in data source or calculated column or measure?

[xiumi_hou]

@az38  column one is a switch function of different measures. Current is the count value of measures. (Each row is a different measure) Thanks!

[az38]

@xiumi_hou 

the issue is somewhere in measures, give us the measure statements to troubleshooting

[xiumi_hou]

@az38 

CALCULATE(

COUNT(Calls[Parent_id])+0,

FILTER(

Calls,

Calls[status]="Cancelled"&&(

Calls[Type_c]="Assessment" ||

Calls[Type_c]="Coaching_booster" ||

Calls[Type_c]="Coaching_completion" ||

Calls[Type_c]="Coaching_Session"||

Calls[Type_c]="Treatment Session" )

)

)

This is my measure, every measure is exactly the same, except change the Call[Status] to held/missing/cancelled....)

[az38]

@xiumi_hou 

try ALL() inside FILTER() like

FILTER(
ALL(Calls),...
)

is it Current measure? or Current has another statement?

[xiumi_hou]

@az38  Thanks, this is my current measure

Current = SWITCH(

                            MIN('Sheet1'[Number]) ,

                            --------------------------------------

                            1,[Count_Sessions_Scheduled],

                            2,[Count_Held_Sessions],

                            3,[Count_Held_Sessions_A1],

4,[Assigned Cases],

5,[Count_Sessions_Missing],

                            6,[Count_Sessions_Cancel],

7,[Count_Sessions_Cancel_within 24hrs],

8,[Count_Sessions_Cancel_outside 24],

9,[Count_Sessions_planned]

                            )

[az38]

@xiumi_hou 

also you can remove all sensitive data from your report and share pbix-file to any cloud service

[v-frfei-msft · Accepted solution]

Hi @xiumi_hou ,

Please create a new measure like that to work on it.

SUMX(your table, [measure])

[az38]

@xiumi_hou 

try CALCULATE() over MIN, like CALCULATE(MIN('Sheet1'[Number])) to use row context and correct summarize in total