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:

     

FarhanAhmed's avatar
FarhanAhmed
Icon for Community Champion rankCommunity Champion
4 years ago

you can try this. Your model should have Date Dimension to get this result. whatever selection you will made through the filters of your date table you will get relative results.

 

Distinct Tag = CALCULATE(DISTINCTCOUNT('Tag'[Date]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-7,DAY))
peteru9067's avatar
peteru9067
Icon for Helper III rankHelper III
4 years ago

Thanks.... I dont know if I understand your measure. what is 'Tag'[Date]

  • FarhanAhmed's avatar
    FarhanAhmed
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Tag[Date] is the date from your orignal table where IPL Tag and Dates column are present.

    Date[Date] is the date column from your date dimension.