Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |