Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bar Chart 1:
Dimension : Region
measure:
if (sum([Quantity]) <> 0,
if (Sum([DailyQuantitySales]) <> 0,
sum({<[Region] ={"=Sum([margin])>=0"} >}[DailySales]) - sum({<[Region] ={"=Sum([margin])>=0"} >}[DailyVarSales]),
sum({<[Region] ={"=Sum([margin])>=0"} >}[DailySales])
)
,0)
Bar Chart 2:
Dimention : Country
if (sum([Quantity]) <> 0,
if (Sum([DailyQuantitySales]) <> 0,
sum({<[Country] ={"=Sum([margin])>=0"} >}[DailySales]) -sum({<[Country] ={"=Sum([margin])>=0"} >}[DailyVarSales]),
sum({<[Country] ={"=Sum([margin])>=0"} >}[DailySales])
)
,0)
Both are giving different total . What could be the reason ?
can you create a sample application and share it?
Aren't you making 2 totally different calculations, as one is looking at Country = and Region =? Maybe you need some identifiers to user alle data
A simple app or data-set would make it easier to solve.