Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
Solved! 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.
Hi,
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.
Hi,
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |