Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi friends,
I need the subtotal based on grouping included date filtering applied at first.
Priority: 1: date slicer filtering
2: sort by Ckey, ItemNo, DB_Ind, Entry No
3: group by Ckey, ItemNo
4: sum qty for inventory OUT only
But currently logic only able cater for item 2,3,4.
The first screen showing sample of raw data about overall inventory including inventory IN & inventory OUT.
inventory IN: Entry Type in {0,2,6} inventory OUT: Entry Type in {1,3,5}
Screen below is what currently I can get the correct result by applying below logic.
Btw, I cant get the result below if date slicer is selected, it still showing overall subtotal as -26 instead of -1.
Thank you.
XioFen
I am not sure I follow. You say you are getting the correct result. So that's good right?
It sort of sounds like a measures total issue to me but that's a complete guess. This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi Mr. Greg,
Yes, I am getting correct subfigure if no filter for date slicer (default showing all record). But if do some selection on date slicer, the subfigure will be wrong because it still showing grouping based on all record instead of record after applied date slicer filtering.
Thank you.
Xio Fen
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |