(dax) Refer to a automatic calculated total field of a column of a table

[manuelz]

Hi, is there a way to refer with dax to a automatic calculated field (total field) of a column of a table?

I have 1 one table with last row that is the the total of the value of the columns (look the image), the totals are calculated automatically and I cannot click on a field of the totals with the mouse. I need to take and refer to a value of one of the totals fields and with this value create a new object.

 I need to refer to the 66.175,38 filed but i don't know how to do because the totals are calculated automatically.

Many thanks in advance

[Anonymous · Accepted solution]

Hi @manuelz ,

You can use a column.

column=sum(table[column1])

Or a measure.

measure=sumx(all(table),table[column1])

Or you can put the column into the card, then you can see the total value now.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manuelz]

Thanks a lot, i will try immediately.