Change Total value in calculation

Marlene Knaup

October 22, 2021 12:46

Hi all,

we use a calculation where the percentage should be shown per user dimension "Year".

So far so good, the formula is: sum(0, 0, m1) / sum(0, all(s), m1)

Is it possible to change the formula that auto. Totals are always 100% per user dimensions?

2 comments

Kristoffer Drejer
October 22, 2021 12:49
You need to create and extra column to my knowledge.

Assuming your % calculations is a column, I would do this and then just hide your first column.
```
if allcount(c1,all(c),0) = 0 then sum(c1,0,0) else 1 
```
0
Marlene Knaup
November 02, 2021 15:21

Hi Kristoffer,

really good, it helped a lot.

(Using calculated measure it is: if allcount(0, all(c), m2) = 0 then sum(0, 0, m2) else 1)

Thank you!

0

Please sign in to leave a comment.

New post