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)
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
