Forum Discussion
line and Clustered Column Chart - count distintic do not exclude "no data values"
hi team, i'm very new to pbi and at the moment I only use the visualization tools and not DAX i'm totally getting crazy since i'm tring to show on a line and clustered column chart some values but i...
Hi Anonymous ,
You can create a measure as below:
count of a = VAR _tab = SUMMARIZE ( 'Table', 'Table'[a], "count of a", CALCULATE ( COUNT ( 'Table'[a] ), FILTER ( 'Table', 'Table'[a] <> BLANK () ) ) ) RETURN SUMX ( _tab, [count of a] )Best Regards
Anonymous , Try like
calculate(distinctcount(Table[column]), filter(Table, not(isblank(Table[column]))))
where should i put it? apologize for my (Stupid) question
Anonymous , I suggested a measure that will not count blank. Hope I got it right.
the system says that syntax is incorrect
calculate(distinctcount(Table[column]), filter(Table, not(isblank(Table[column]))))
where should i put it and how do i understand which is the table and the column name? thanks