Forum Discussion
Help with DAX measure
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 Sorry about the confusion/vagueness within my first post. I have a table that contains Projects, a table that contains Employees, a table that contains time from System 1, a table that contains time for System 2, and a table that contains the Pay Period Dates as well as a number of other tables that provide additional information that help to create all of the relationships between the tables. Employee is not included in the sample data matrix because it is not a field in that matrix. Instead, I have used a slicer to allow the user to filter by Employee.
I hope that helps. --Shauna
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