how to substract column and measure

[Rosner_]

hello,

I have table with 10 columns 

one of the column is revenue

and I create new aggregate measure name group_sum

now I try to to substract the group_sum - revenue  and it doesn't give me right results 

tried:

sumx(tbl,(group_sum -revenue))

group_sum -revenue 

I know it's make no sense to do it, it's only for understanding how to create calculations between field from the table and the new calculated measure 

** I can only use calculated measure

any help will be appreciated 

thank you

[Rosner_ · Accepted solution]

thank for the reply:

I think it's  just an issue of the data and maybe because of security (at work)

I apply it in my laptop with clean data and right data type without any restrictions, it's works properly 

thank you .

[Anonymous]

Hi @Rosner_,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[lbendlin]

A measure has no meaning if nobody is there to set filters. Then it becomes just another calculated (immutable) value.

group_sum needs to be a calculated column.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...