Absolute Value

[Anonymous]

Hi there

I'm pretty new to PowerBI where I am currently in trouble in regard to calculating the absolute value of data fields.

My visualization currently looks like:

Product.      Sales.      Forecast.      Dif.      AbsDif

Category1       90               117               -27           27

   SKU1.            1                 0                   1               1

   SKU2             2                0                    2               2

   SKU3            87              117                 -30          30

I have calculated/transformed the difference to absolute value, but I don't understand why the total AbsDif of the SKU's (category1) does not total 33?

Hope you can help.

[Anonymous]

@Pragati11 

I think I have solved it by using the following formula:

AbsBias = SUMX(VALUES('Table1'[SKU]),CALCULATE([AbsBias],ALL('Table1'[Category])))

[Pragati11]

Hi @Anonymous ,

Can you share your calculation for Absolute difference please?

Thanks,

Pragati

[Anonymous]

Ofc 🙂 @Pragati11 

Bias = CALCULATE(SUM('Table1'[Sales])-SUM('Table2'[Forecast]))

AbsBias = CALCULATE(ABS(SUM('Table1'[Sales])-SUM('Table2'[Forecast])))

[Pragati11]

Hi @Anonymous ,

As you want your totals to be affected by your absolute value, you can write your measure something as below:

AbsBias = CALCULATE(ABS(SUM('Table1'[Sales])-SUM('Table2'[Forecast]))) * (-1)

Check if this helps.

Thanks,

Pragati

[Anonymous]

---

@Pragati11 wrote:

Hi @Anonymous ,

As you want your totals to be affected by your absolute value, you can write your measure something as below:

AbsBias = CALCULATE(ABS(SUM('Table1'[Sales])-SUM('Table2'[Forecast]))) * (-1)

Check if this helps.

Thanks,

Pragati

---

---

@Pragati11 wrote:

Hi @Anonymous ,

As you want your totals to be affected by your absolute value, you can write your measure something as below:

AbsBias = CALCULATE(ABS(SUM('Table1'[Sales])-SUM('Table2'[Forecast]))) * (-1)

Check if this helps.

Thanks,

Pragati

---

@Pragati11 

That just makes all of the values negative. 

[Pragati11]

Hi @Anonymous ,

I just realised I understood your query wrong.

What do you mean by this in your statement:

I have calculated/transformed the difference to absolute value, but I don't understand why the total AbsDif of the SKU's (category1) does not total 33?

I don't understand the colored section of your comment.

This is basically the table I tried to reproduce at my end:

Where in the above table are you expecting 33 as a total?

Also see the image below, is my understanding correct based on the data you are using:

Thanks,

Pragati

[Anonymous]

@Pragati11 

So in the table you have created, the "Total" row is the "Category1" row in my table. 

[Anonymous]

@Pragati11 

In my visualization i've created i Matrix visual, where the SKU's are a part of the "Category". So the Category row is basically the total of the SKU's. Therefore the total of the AbsDif should be 33, as the category value is not relevant. 

Hope you understand 🙂