Forum Discussion
Niraj_vora0106
Helper III
3 years agoGrand Total logic
Hi community,
I need help in creating one logic.
In the snip below as you can see there are 2 Materials, PAM and PCM (metioned in row) and 10 Plants (mentioned in column) and Quantities as values.
I want to see only those Materials whose values (Quantities) Grand Total are negative.
Like in the snip we can see PCM's Grand Total is negative ie: -38
1 Material across Plant and 1 Material Quantity across negative.
Please help!
1 Reply
- Greg_Deckler
Community Champion
Niraj_vora0106 You could create a Complex Selector for this: The Complex Selector - Microsoft Power BI Community