Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a simple visual below where the query has several columns but I just pulled below 3 columns from the query , it shows belo data which is right. Here the Conf_Qty is selected as Don't Summarize
But when I summarize it it shows me below
The summation is clearly shows way large while it should show 36, theer are 2 filters I applied i.e. for Delivery Date Employee ID.
Please guide how to show the right summation here?
Thanks
Solved! Go to Solution.
Hi @srlabhe123 ,
Please try this measure:
Measure =
sumx(SUMMARIZE('Table',[conf_qty]),[conf_qty])
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@srlabhe123 , when displaying Conf_Qty as don't Summarize, then it displays grouped data, which means if values are repeated they are not showing as separate rows. Power BI always show distinct data.
to check that in first visual put Conf_Qty again as sum
They are showing as below
Hi @srlabhe123 ,
Please try this measure:
Measure =
sumx(SUMMARIZE('Table',[conf_qty]),[conf_qty])
Result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |