Cannot use defaul sum or count for column in any visualization

[DarkSandy]

Hi all,

I have one column in my table formated to decimal number (formating goes directly from PQ). Please see it bellow.

WHen i try to use this column in visual (matrix/pivot/any other) calculation, i do not have the possibility to chose defaul sum, count option = if i want to sum this column, I need to create a measure. The same happen for any other column in my data model. Bellow you can see the issue .

 

I recently installed Tabular Editor and experimented a bit with calculation groups, so might be that I have by mistake did something in settings or something else,

Thanks,

DS.

[FrankAT]

Hi @DarkSandy ,

with your sample data I can't reproduce your situation (see figure).

 Regards FrankAT

[Greg_Deckler]

@DarkSandy - So you have a column called MarketingCost in your MarketingCost table?

[ilton]

Hi! @DarkSandy 

When using a measure on a table you need to chose a category attribute day, month year, store etc.

Consider marking this as a solution if it solved your problem.