Forum Discussion
Solved
Help with DAX measure
My organization has two time entry systems. I have created a matrix that shows the total number of hours entered into each system, per project, that can be filtered by employee and pay period. A samp...
In that case, then somthing like this should work:
Measure = VAR __Table = SUMMARIZE( 'Table',[Project], "__Comp",[Comparison] ) RETURN IF(COUNTROWS(FILTER(__Table,[Comparison] <> 0)) = 0,"Good","Bad")
Greg_Deckler Thank you so much! This worked (and I marked it as a solution), but I would prefer for blanks to be considered "Bad." How should I change the IF statement to accomplish that?
smstrickland - Great! Not sure I follow though on your follow-up question.
Measure =
VAR __Table =
SUMMARIZE(
'Table',[Project],
"__Comp",[Comparison]
)
RETURN
IF(COUNTROWS(FILTER(__Table,[Comparison] <> 0)) = 0,"Bad","Good")?
Greg_Deckler Never mind the last question, and thank you again for your help. --Shauna
- No problem! 🙂