Invalid Sum Showing for a measure

[srlabhe123]

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

[amitchandak]

@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

[srlabhe123]

They are showing as below 

[v-chenwuz-msft · Accepted 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.