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")
Well, it is very difficult to be specific because you talk about a person and wanting to display by person but there is no person in the sample data and no information about if the person name is in the table or another related table, how those tables are related, etc.
So, I can provide a general solution. Use SUMMARIZE or GROUPBY to summarize by person and by project and add in your Comparison measure/column. Filter that such that you filter out any 0's for Comparison. Do a COUNTROWS. If COUNTROWS is 0/BLANK then no discrepencies. Otherwise, discrepencies.