cross filter not working with calculate

[nick9one1]

I have a date dimension table that doesnt seem to be crossfiltered when I use calculate. Can anyone help?

this is my measure;

SLA - Percent = COUNT(SLA[OrderKey])/CALCULATE ( COUNT(SLA[OrderKey]),ALLEXCEPT(SLA,SLA[OrderType]))

[v-sathmakuri]

Hi @nick9one1 ,

I hope this information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!1

[v-sathmakuri]

Hi @nick9one1 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

[v-sathmakuri]

Hi @nick9one1 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @danextian  and @bhanu_gautam  for the prompt response.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[danextian]

Hi @nick9one1 

The SLA crossfilters the dates table solely based on the related columns. A measure does not directly influence crossfiltering. Given that the relationship is between PlannedStartDateKey and Date, selecting a value in SLAStatusHighLevel will crossfilter the dates table only for the dates common to both tables when that value is chosen.

If you want the date slicer to be filtered, add the measure as a visual filter and select is not blank from the filter options. This approach won't work with a range slicer.

[bhanu_gautam]

@nick9one1 , Try using

DAX
SLA - Percent =
VAR TotalOrders = COUNT(SLA[OrderKey])
VAR FilteredOrders = CALCULATE(
COUNT(SLA[OrderKey]),
ALLEXCEPT(SLA, SLA[OrderType]),
VALUES(DateDimension[DateColumn])
)
RETURN TotalOrders / FilteredOrders

[nick9one1]

thanks, 

I have changed the measure but I still get all dates in the dimension table.