Forum Discussion

wouterDefour's avatar
wouterDefour
Frequent Visitor
5 years ago

ALL function not applied on second visual

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 ...
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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's avatar
wouterDefour
Frequent Visitor
5 years ago

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's avatar
    wouterDefour
    Frequent Visitor
    5 years ago

    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.