Not able to See attrition % based on Division

Hello Ankurdatascienc 

In termination table add employeeID column and connect with Termination details Employee ID column.

It will solve your probelm

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Ankurdatascienc 
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

Hi Ankurdatascienc,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Hi Ankurdatascienc,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Hi Ankurdatascienc,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query