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 )
Matas
Please try
Extracted =
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 )
tamerj1 wow, that worked!
Thank you so much! Could you please explain the logic behind? Since I will need to apply this logic to some other functions to get Validated fields, etc.