Forum Discussion
ClemFandango
Advocate II
Advocate IIHow 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 ( ...
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
ClemFandangoAdvocate II
Advocate IIMany thanks marcl1, I really appreciate the response. Creating a VAR virtual table is a completley new concept to me. Do you have any examples of how I would do that? I am just checking that I am following you correctly, would the VAR virtual table condense Table1, providing just unique AccNum's?
marcl1
Helper II
Helper IIVAR __tab = filter(SUMMARIZE('Table1',[column1],...), ...)
RETURN
countrows(__tab)
think that this virtual table is like a pivot so you get 1 line by accnum