DAX - Help

Hi Anonymous,

You can try to use below formula to get the different count of year group.

Summary table =
SUMMARIZE (
    ADDCOLUMNS ( Table, "Year", YEAR ( table[Date] ) ),
    [Year],
    "Count Titile", DISTINCTCOUNT ( Adnumber[Title] ),
    "Count AD", DISTINCTCOUNT ( Adnumber[Adnumber] )
)

Regards,

Xiaoxin Sheng

Hi Anonymous,

Create a calendar table and extract year from the data column of the calendar table using the YEAR() function.  Create a relationship from the Date column of your data table to the date column of your calendar table.  Drag year from the calendar table to the visual or as a silcer or to the filter section.  Select a particular year.  Now use the IDSTINCTCOUNT() function.