Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
Try the DAX which is given by @V-pazhen-msft .
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.
Try the DAX which is given by @V-pazhen-msft .
Kindly share the sax formula for the measure. So it would be easier for tackling the issue.
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
I am not using any Dax formula, Simply doing distinct count of Sys-id, if you have any Dax to correct this total
change your sym_id to SUM and not Count 😉
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |