Variance of a measure on its total

[kostask]

Hi guys...

I created a   measure, let's say EBIT% on sales (EBIT / sales) and I use it on a matrix lets say per shop.

How can I calculate in the next column of my matrix the variance between the EBT % of the shop and the total EBT of the business?

Thanx!

Kostas

[Anonymous]

Hi @kostask,

I'd like to suggest you take a look at the following blog to know how to check current row content level and write different formulas to handle the total level calculations:

Clever Hierarchy Handling in DAX 

Regards,

Xiaoxin Sheng

[Fowmy]

@kostask 

Can you try this measure, rename Table to your table name 

Measure = 

CALCULATE (
 [EBIT/SALES],
ALLSELECTED(TABLE[SHOP])
)
-
[EBIT/SALES]

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn