Forum Discussion

peteru9067's avatar
peteru9067
Icon for Helper III rankHelper III
4 years ago
Solved

Distinct 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...
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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:

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

peteru9067 , Try a measure like

countrows(summarize(Table, Table[Date], Table[Tag]) )

 

date should not have a timestamp, else create a new column

 

Date Only = datevalue([Date])

 

the measure

countrows(summarize(Table, Table[Date Only], Table[Tag]) )

peteru9067's avatar
peteru9067
Icon for Helper III rankHelper III
4 years ago

Thanks for the help......... you have provided the total count........ what I am looking for is unique count per day for x number of days so 177-LSHH-0018 will only appear a total of 3 times (for 5/8/2022, it will only count it as once)