DAX Measure to Ignore Date Slicer

[ggzmorsh]

Good Day,

I have a date slicer with a direct relationship with the table of unique values that I want a measure to ignore regardless of the active date slicer on the same visual page.

I used the formula "ALL" to give me the total count of all unique ID in the table ignoring the slicer.

Measure=CALCULATE (COUNT (Unique ID[ID), ALL('Calendar'[Date]))

But... I want this measure to have a filter for a specific value which i used next as 

Measure = CALCULATE(COUNT(Unique ID[ID),FILTER(UniqueID,'Unique ID[Attempts ID]=FALSE()),ALL('Calendar'[Date]))

Using this formula the date slicer is affecting the measure. Can someone please correct me if the measure i using is wrong.

[Jihwan_Kim]

Hi, @ggzmorsh 

If it is OK with you, please share your sample pbix file, then I can try to come up with a more accurate measure.

Thank you.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.