Forum Discussion
Running count with a filter
amitchandak Thanks for trying to help with this - however, I have woken up a bit now and made a custom column that allows 'flexible' to act as a seperate filter (instead of trying to do it in the same column).
All works now! Thanks again for trying to help, greatly appreciated.
Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Check if Window function can help
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
To give a quick example as I can't attach on my current slow connection.
| 1 | office |
| 1 | field |
| 2 | home-based |
| 3 | home-based |
| 3 | field |
| 4 | home-based |
| 4 | field |
| 4 | flexible |
| 5 | flexible |
| 5 | home-based |
| 5 | office |
| 5 | field |
So, the normal counts would be
Office - 2
Field - 4
Home-based - 4
Flexible - 2
But then we would filter on the flexible field so the count would be (just ids 4 & 5 are marked as flexible)
Office - 1
Field - 2
Home-based - 2
Flexible - 2