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) whi...
Need Help
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.