Need DAX to show a table visual with Difference between two identical measures

[Anonymous]

Hi Microsoft Team,

From the above image, we are comparing components ID with respect to Gross profit and % based on Year,Month, country slicers.

Now, I would like to create other table visual which can show the difference between two component ID gross profit and % values.

eg., 144756- 8854 =value

Note- here Gross profit and % measures which are used are same in both sides.

Thank you

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep 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]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Please show the expected outcome.