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
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.
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