Help : DAX : Giving wrong result

[Chandrashekar]

Hello,

am trying below DAX to get count based on condition. As per chart I need to get 2139 but am getting 207.

In Calendar table I have inactive relation for date_closed

DAX: ClosedCount_Pr = CALCULATE(COUNT(tk[Number]), USERELATIONSHIP(tk[Date_Closed], 'Cal'[Date]),FILTER(all(tk),'tk'[Pr/Re]="PR") )+0

Expected Result:

[Anonymous]

Hi @Chandrashekar ,

I think your issue should be caused by your data model. Please share a sample file with us and show us a screenshot with the result you want. This will make it easier for you to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chandrashekar]

Hello,

Unfortunately cannot able to share data as it is confidential .

Regards,

Chandrashekar B