Forum Discussion

PowerB1Rookie's avatar
PowerB1Rookie
New Member
3 years ago
Solved

How would I calculate column values for each row?

Hi, 

 

I have a table with multiple comparison columns like below:


Person   Rent    Paid    Void 

1            Yes      No      No 

2            No      No      No

3            Yes      Yes      Yes

 

the table I have is a lot bigger and has about 20 columns with various yes/no fields in each. 

How would I calculate how many yes/no's there are for each person/row?

 

Need Help
  • Shreeram04's avatar
    Shreeram04
    3 years ago

    Hi PowerB1Rookie 

     

    Please find the below screenshot for your reference.

     

    Measure:

    yes = var paid= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Paid]="Yes"))
    var rent=CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Rent]="Yes"))
    var void= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Void]="Yes"))
    return
    paid+rent+void
     
    No = var paid= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Paid]="No"))
    var rent=CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Rent]="No"))
    var void= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Void]="No"))
    return
    paid+rent+void
     
    Screenshot:

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

    thanks,

1 Reply

  • Shreeram04's avatar
    Shreeram04
    Icon for Resolver III rankResolver III
    3 years ago

    Hi PowerB1Rookie 

     

    Please find the below screenshot for your reference.

     

    Measure:

    yes = var paid= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Paid]="Yes"))
    var rent=CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Rent]="Yes"))
    var void= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Void]="Yes"))
    return
    paid+rent+void
     
    No = var paid= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Paid]="No"))
    var rent=CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Rent]="No"))
    var void= CALCULATE(COUNTROWS('Table'),FILTER(ALLSELECTED('Table'),'Table'[Void]="No"))
    return
    paid+rent+void
     
    Screenshot:

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

    thanks,