Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX ALL() - Working Problems

Hello,

 

In one page we have several visuals, and several slicers.

 

Two of those visuals are this 2 tables. And this table are all affected by the slicers, except one slicer (slicer = slots) which doesn’t affect one of the visual

 

1st table – its not affect by the slicer “slots” – shows the behavior without that slicer

2nd table – its affected by all the slicers – shows the variation of the behavior of the first table with the filter “slots”

 

Both tables have:

 

“Semana” =Week

5 periods of time = 1st period; 2nd period… and so on until the 5th period

 

So basically the formula to do the variation of “NumofWork.” Is:

 

Var. Work = sum(table[NumofWork])-calculate(sum(table[NumofWork]);all(table[slots]))

 

The problem is that this doesn’t work… and we cant figure it out.

 

For example:

 

The first table its equal

The 2nd table is just a validation of the formula, so its just the:

 

calculate(sum(table[NumofWork]);all(table[slots]))

 

 

In theory both tables should be similar…

 

But in the 2 to 5 period of time, the data is different.

 

 

What could provoke this difference?

 

Can you shine a light???

 

(cant send the pbix cause is confidential)

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi VanessaAG,

     

    Could you please share the pbix file with some dummy data? We need it to reproduce this problem.

    According to your description, my understanding Is that the result of sum(table[NumofWork]) and calculate(sum(table[NumofWork]);all(table[slots])) are not same even when the slicer has not been selected.

    Based on my test, the two measure should be same when the slots slicer has not been selected:

    Please refer to the following pbix file and check if you have configured other thing.

    https://1drv.ms/u/s!Ao9Of0JgO6MU7WHfNySUP6O0_GZi

    Best Regards,

    Teige

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      TeigeGao  The file its huge, its dificult to reproduce with false data.

       

      Your pbix its working, and i have other pbix dashboards in which this formula works.

       

      But in this one doesnt work.

       

      I think i have to start over with the data behind the dashboard and try to understand what is messing the formula.