cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
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.

 

Total.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How Can i calculate Total in power BI

@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.

View solution in original post

Highlighted
Super User III
Super User III

Re: How Can i calculate Total in power BI

@Mahmoodul ,

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!!!
You can follow me on LinkedIn

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

View solution in original post

6 REPLIES 6
Highlighted
Resolver I
Resolver I

Re: How Can i calculate Total in power BI

change your sym_id to SUM and not Count 😉

Highlighted
Super User III
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!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted
Helper I
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
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

right total.png

The way it is current is aggregating the Count

wrong total.png

Regards

rubin

Highlighted
Community Support
Community Support

Re: How Can i calculate Total in power BI

@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.

View solution in original post

Highlighted
Super User III
Super User III

Re: How Can i calculate Total in power BI

@Mahmoodul ,

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!!!
You can follow me on LinkedIn

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

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors