cancel
Showing results for
Did you mean:
Highlighted Helper I

## How Can i calculate Total in power BI

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. 2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted Community Support

## Re: How Can i calculate Total in power BI

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.

Highlighted Super User III

## Re: How Can i calculate Total in power BI

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created report:
My Report
6 REPLIES 6
Highlighted Resolver I

## Re: How Can i calculate Total in power BI

change your sym_id to SUM and not Count 😉

Highlighted Super User III

## Re: How Can i calculate Total in power BI

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created report:
My Report
Highlighted Helper I

## Re: How Can i calculate Total in power BI

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

Highlighted Resolver I

## Re: How Can i calculate Total in power BI

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

Highlighted Community Support

## Re: How Can i calculate Total in power BI

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.

Highlighted Super User III

## Re: How Can i calculate Total in power BI

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created report:
My Report  