Aggregate not working, can anybody give helps

[stephensklam]

Where is the wrong setting can make aggregation missed?

[pranit828]

Hi @stephensklam 

The Column you are trying to aggregate is not a number field. It it was it will show as a summarization symbol left to it.

Click on the cost as in the above screenshot and make sure your formula bar shows as in the below.

[stephensklam]

[Cost] being Setting as decimal number, but can't display as number

[v-diye-msft · Accepted solution]

Hi @stephensklam 

I just tested it, and it works fine on my side, plz make sure you're using the latest desktop version. if the problem still exist, 

you can try to add the measaure to approach the aggregation : SUMX(table,table(value))

You can also share your dummy pbix that we can investigate it further.

[mhossain]

@stephensklam 

Go to Edit query --> make sure values field, COST and MOQ are in decimal format , seems current it's not integer.

Please let me know if this helps

[stephensklam]

Thanks mhossain, cost is decimal format, both even unable to COUNT, DISTINCT COUNT...

[mhossain]

@stephensklam 

Great, try matrix table, there you will be able use functions.