Forum Discussion
Not able to See attrition % based on Division
Ankurdatascienc
Use CROSSFILTER function as per your filter propogation in the model..You need to setup CROSSFILTER for each measure based on your current model health.
I suggest you to have a read on below blog in order to have some idea how this relationship works in power bihttps://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Hope it helps
Regards
sanalytics
Super UserAnkurdatascienc
Brother, Please create a proper dimensional Data model tarting any development—it will make your work significantly easier and more efficient..
Based on your current model and to help save your time, you can use the below code to achieve your solution
Attrition CrossFilter =
CALCULATE(
[Attrition rate %],
CROSSFILTER( d_Date[Date],Terminations_details[Month],Both )
)
Hope it helps
Regards
sanalytics
Thanks But one more query that Division slicer is working to filter for terminations but I want it to work for Current Headcount and hires as well. Please help
- sanalytics
Ankurdatascienc
Use CROSSFILTER function as per your filter propogation in the model..You need to setup CROSSFILTER for each measure based on your current model health.
I suggest you to have a read on below blog in order to have some idea how this relationship works in power bihttps://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
Hope it helps
Regards
sanalytics