topic 2 bar chart having same expression but different dimension different results in App Development

2 bar chart having same expression but different dimension different results

prashantsanchet — Thu, 08 Mar 2018 07:40:44 GMT

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 ?

shraddha_g — Thu, 08 Mar 2018 08:54:24 GMT

can you create a sample application and share it?

hacr — Thu, 08 Mar 2018 13:57:30 GMT

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.