Forum Discussion
Solved
Complex open requisitions over time
I have a data set that contains (far more than this): Requisition ID Approved Date Status Date Filled Start Date 1 22/10/2021 Filled 02/02/2022 21/06/2022 2 15/11/2021 Filled ...
tomskelly89 , refer if the blog on similar topic can help
Thanks Amit,
This has certainly solved my issue with the multiple line bar chart I have.
The only thing now is when I want to show the source of hire which is only looking at requisitions that are with a status of "Filled" this is now showing the incorrect %.
This would also need to be filtered by TAq Partner.
Any ideas?
You need a measure like
Divide( calculate([Measure] , filter(Table, Table[Status] ="Filled")), [Measure])
What would i replace [Measure] with?