Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a requirement as described below and any help is much appreciated.
I have a table with some 20 columns, However I have to count Bin Numbers based on group by of four columns in the table. and then filter by another fifth column.
Example -
For a combination of Warehouse, Storage Type, Section, Bin Type get the count of Bin Numbers where Status = ‘X’. This is count of Empty Bins.
How can I group just on four columns out of 20 columns in the table. If I create new table with four columns summarized and grouped by, in that case I am not able to filter on fifth column.
Any Thoughts!!
Solved! Go to Solution.
@Anonymous
I'm still not quite clear about your requirement. Do you want to group values based on four columns values?
Since the grouping feature can only work on singe column values, you have to create a column combining all 4 columns.
And it's not supported to add filter in "Edit Groups". But you can apply a Visual Level Filter with STATUS = "X" on the visual, then create the grouping, it will take the current filter for creating group. I think this is the only way to achieve your goal currently.
Regards,
@Anonymous
I'm still not quite clear about your requirement. Do you want to group values based on four columns values?
Since the grouping feature can only work on singe column values, you have to create a column combining all 4 columns.
And it's not supported to add filter in "Edit Groups". But you can apply a Visual Level Filter with STATUS = "X" on the visual, then create the grouping, it will take the current filter for creating group. I think this is the only way to achieve your goal currently.
Regards,
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |