ALL function not applied on second visual

[wouterDefour]

Hello,

I'm having some difficulties with the ALL() function.

My datasets looks like:

Remark	Day	Tonnage
a	1	530
x	2	0
y	3	0
z	2	0

What I want, is the tonnage to be repeated over all rows:

Remark	Day	Tonnage
a	1	530
x	2	530
y	3	530
z	2	530

Therefore, I added following measure: CALCULATE(SUM( Table[Tonnage] ), ALL(Table[Remark] ))

It works fine at first sight:

 But when selecting a Remark on one visual, I get:

On the selected visual, the tonnage is still correct, but on the second visual, the formula fails.

It looks like the ALL-function is not applied anymore on the second visual.

Any help would be appreciated, how I could accomplish this.

Thanks!

[selimovd]

Hey @wouterDefour ,

do both visuals contain exactly the same fields from the same tables?

Are all the fields also from the same table or are you using dimensional and fact tables?

Best regards

Denis

[wouterDefour]

Hello @selimovd ,

Both visuals are identical ( I copied them).

There is only one table involved, with the corresponding fields.

It has something to do with the bussiness behind.

Some remarks occur at a date, where there is no tonnage.

the tonnage are >0 on day 6 and 16. But some remarks have no records on those days.

eg, remark "Griffes Diverses" below only occurs on day 26:

It looks like the second visual is also filtered according to the date, although I did not select the date.

Thanks for your interest!

[wouterDefour]

I found the cause:

I have a date slicer on the PowerBI report. When this date slicer is used (does not select "all"), even thought, the way it filters is not relevant to the report, the other visual are calculated in a wrong way.

I managed to find a work around by making a new date table, linking this in the model and use a slicer on this new table instead of a slicer on the date in the main table.

It works, but I don't understand why.