The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@DarkSandy - So you have a column called MarketingCost in your MarketingCost table?
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.
User | Count |
---|---|
79 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
108 | |
99 | |
55 | |
49 | |
45 |