Forum Discussion

prasadhebbar315's avatar
prasadhebbar315
Advocate I
3 years ago
Solved

Summarize data based on conditions

Hello, I need help in creating a Result column from the below table based on the condition that both Col1 and Col2 should atleast contain Yes for a Serial_Number. If yes, then the entire Serial_Numb...
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    Result=IF(COUNTROWS(FILTER(Table,Table[Serial_Number]=EARLIER(Table[Serial_Number])&&Table[Col1]="Yes"&&Table[Col2]="Yes"))>0,"Yes","NO")

MohTawfik's avatar
MohTawfik
Resolver I
3 years ago

prasadhebbar315 

If you want to create this calculation in the table, go to data view, click on new column and type the below formula:

Result =
 IF( 'Table'[Col1] = "Yes" || 'Table'[Col2] = "Yes",
 "Yes",
 "No")

If you want to do this in the report as a measure, go to report view and add new measure as follow:
Result measure =

Var COl1Value =
SELECTEDVALUE('Table'[Col1])

Var Col2value =
SELECTEDVALUE('Table'[Col2])

Return

 IF( COl1Value = "Yes" || Col2value = "Yes",
 "Yes",
 "No")