Forum Discussion
peteru9067
Helper III
Helper IIIDistinct count over a period
I have a table with Tags and Dates...... I would like to count the distinct number of times a tag appears over a time period i.e. 7 days. so if the tag appears multiple times in one day, it should on...
peteru9067 not sure if this is what you meant but if you just create this measure:
Appears = DISTINCTCOUNT('Table'[Date])
and put the IPL tag on the bar axis than you will get the distinct count of days for each one for every time period you will choose on an outside filter or slicer:
SpartaBI
Community Champion
Community Championpeteru9067 not sure if this is what you meant but if you just create this measure:
Appears = DISTINCTCOUNT('Table'[Date])
and put the IPL tag on the bar axis than you will get the distinct count of days for each one for every time period you will choose on an outside filter or slicer:
and put the IPL tag on the bar axis than you will get the distinct count of days for each one for every time period you will choose on an outside filter or slicer:
peteru9067Thanks a lot but what do you mean by outside filter
- SpartaBI
peteru9067 let's say I added a slicer with dates:
If I will change the dates there, the chart will show the appears for that period.
- peteru9067
For some reason mine is showing 365