My requirement is create measure which calculate distinct count of rows and i have one date column which i need to check with user selected Date slicer.
Go to Solution.
Hi @Anonymous ,
Did you create relationship between date table and the fact table in your scenario? Here I created a sample for your reference.
Measure = CALCULATE(DISTINCTCOUNT(NETWORK[Merged Colum]),FILTER('NETWORK','NETWORK'[EFFECTIVE_DT]<=SELECTEDVALUE('Date'[Date])))
Pbix as attached.
View solution in original post
Create a relationship from the EFFECTIVE_DT column to the Start Date column of the Date Table. Create a slicer and drag Start Date column from the Date Table. Select a Date there. Write these measure
Count = DISTINCTCOUNT(NETWORK[Merged Colum])
CONTROL PROVIDERS = CALCULATE([Count],DATESBETWEEN('Date'[Start_Date],MINX(ALL(Date),'Date'[Start_Date]),MAX('Date'[Start_Date])))
Hope this helps.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.