Forum Discussion
Slicer In Table A filters Table B based on multiple conditions
So i have 'Table A', which is a list of unique customers. Table B is the total inventory, and a different column for each customer. If a customers column has the value '1', that means that the custom...
Your sample was close to what i needed but the grand total column isn't showing accurate aggregations. I only need the grand total column to work. (not the grand total of rows)
dax
Community Support
Community SupportHi Anonymous ,
If possible, could you please inform me your expected output(grand total )? In my logic, when grand total =1, it represents that it have storage.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My data is structured differently than the example you attached. The formula doen't work. In my case i cannot restructure the data