dw700dPost Patron2 years agoSolvedif statement help I would like to create an if statement measure and place it in a card. The measure would say if the total amount of any Acct Cd is above 0 then Fail else Pass. So for example the table below would re...Show Moreparry2k2 years agodw700d add a measure like this: Fail/Pass Measure = VAR __Check = COUNTROWS ( FILTER ( SUMMARIZE ( Table, Table[Acct Cd], "@Amt", SUM ( Table[Amount] ) ), [@Amt] > 0 ) ) RETURN IF ( __Check > 0, "Fail", "Pass" )
parry2k2 years agodw700d add a measure like this: Fail/Pass Measure = VAR __Check = COUNTROWS ( FILTER ( SUMMARIZE ( Table, Table[Acct Cd], "@Amt", SUM ( Table[Amount] ) ), [@Amt] > 0 ) ) RETURN IF ( __Check > 0, "Fail", "Pass" )
parry2k2 years agodw700d add a measure like this: Fail/Pass Measure = VAR __Check = COUNTROWS ( FILTER ( SUMMARIZE ( Table, Table[Acct Cd], "@Amt", SUM ( Table[Amount] ) ), [@Amt] > 0 ) ) RETURN IF ( __Check > 0, "Fail", "Pass" )
parry2kSuper User2 years agodw700d add a measure like this: Fail/Pass Measure = VAR __Check = COUNTROWS ( FILTER ( SUMMARIZE ( Table, Table[Acct Cd], "@Amt", SUM ( Table[Amount] ) ), [@Amt] > 0 ) ) RETURN IF ( __Check > 0, "Fail", "Pass" )
Related contentOR Statement ?SQL Statement opcion errorSupport for MERGE statementIF Statement using Power QueryNew Column with IF STATEMENT
