How Can i calculate Total in power BI

[Mahmoodul]

Hi How can i calculate Total in Power BI, If you see in Table in the below Total is not correct, Can you please help me to calculate total using DAX.

[V-pazhen-msft · Accepted solution]

@Mahmoodul 

Try this measure:

Count = Calculate(Distinctcount(Table[sym_id]),Filter(All(Table),[ets_rec_accuracy]=Max([ets_rec_accuracy]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[V-pazhen-msft · Accepted solution]

@Mahmoodul 

Try this measure:

Count = Calculate(Distinctcount(Table[sym_id]),Filter(All(Table),[ets_rec_accuracy]=Max([ets_rec_accuracy]))

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24 · Accepted solution]

@Mahmoodul ,

Try the DAX which is given by @V-pazhen-msft .

[Tahreem24]

Kindly share the sax formula for the measure. So it would be easier for tackling the issue.

[rubinboer]

no need for the additional measure, in case I'm missing something.

what is proposed in the response is that you change the aggregation of the visual to SUM as below

The way it is current is aggregating the Count

Regards

rubin

[Mahmoodul]

I am not using any Dax formula, Simply doing distinct count of Sys-id, if you have any Dax to correct this total

[rubinboer]

change your sym_id to SUM and not Count 😉