Forum Discussion

ClemFandango's avatar
ClemFandango
Icon for Advocate II rankAdvocate II
3 years ago
Solved

How to count distinct rows in DAX custom column?

Hellloooo I have the following DAX formula that counts the number of rows based where the date ‘MMYYDD’ (in my calendar table) falls between the min and max dates (table1).   Count = COUNTROWS ( ...
Need Help
Show and Tell
  • marcl1's avatar
    marcl1
    3 years ago

    VAR __tab = filter(SUMMARIZE('Table1',[column1],...), ...)

    RETURN
    countrows(__tab)

    think that this virtual table is like a pivot so you get 1 line by accnum

marcl1's avatar
marcl1
Icon for Helper II rankHelper II
3 years ago

Hi,

you can create a VAR virtual table with the function summarize

then you make the countrows on this virtual table...