Use Slicer in DAX formula to calculate

[mihaita_baro]

Hi

I have 3 tables which i merged them and looks like below picture.

I want to show for each Caseload how many KPI4.LPTID, KPI5.LPTID and KPI6.LPTID are for a specific month.

I've created a Date table as well and i want to write a formula that calculate what i said.

For example if i select April in my Slicer (based on Date Table) i want to see how mani KPI4, KPI5 and KPi6 for each CaseLoad

I was trying like : 

KPI5Measure = COUNT(Merge2[RawDataKPI5.LPTID]) - and here i wanna say if slicer is selected aprile=KPI5EndDate to do the calculation

Or if you guys have an easier version would highly appreciate

[V-pazhen-msft · Accepted solution]

@mihaita_baro 

You also need to count by CaseLoad so you can try following measure, then select month in the slicer or filter.

KPI5Measure = Calculate(COUNT(Merge2[RawDataKPI5.LPTID]), Filter(Allselected(table), [Referral_CaseLoad]=MAX([Referral_CaseLoad]))

Just change the kpi column for KPI4 and KPI6. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.