Forum Discussion
Solved
Calculations using DAX
Hi guys, I am having a table with 18k+ rows, but it is only 715 unique (DISTINCT) ID's, which means only 715 unique documents with different ID's. I am trying to get the "Extracted" values, which...
Matas
Please tryExtracted = VAR T1 = VALUES ( TableName[DOCID] ) VAR T2 = ADDCOLUMNS ( T1, "@NumOfBlanks", SUMX ( CALCULATETABLE ( TableName ), IF ( TableName[Value] = BLANK (), 1 ) ) ) VAR T3 = FILTER ( T2, [@NumOfBlanks] = BLANK () ) RETURN COUNTROWS ( T3 )Blanks = VAR T1 = VALUES ( TableName[DOCID] ) VAR T2 = ADDCOLUMNS ( T1, "@NumOfBlanks", SUMX ( CALCULATETABLE ( TableName ), IF ( TableName[Value] = BLANK (), 1 ) ) ) VAR T3 = FILTER ( T2, [@NumOfBlanks] <> BLANK () ) RETURN COUNTROWS ( T3 )
