cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
send2mark
Helper V
Helper V

CountRows Subtract from Total

What I have below works for counting what I have based on a choice dropdown column called Session. What I would like is to have a calculation that subtracts from 15. That number is all the seats I have in total. 

 

Text="Available seats : " & CountRows(Filter(Event1, Session.Value="Session 1"))

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@send2mark 

Text property of a label:

 

 

"Available seats : " & 15 - CountRows(
                                      Filter(
                                              Event1, Session.Value="Session 1"
                                       )
                             )
                                  

 

 

 

View solution in original post

1 REPLY 1
Drrickryp
Super User
Super User

@send2mark 

Text property of a label:

 

 

"Available seats : " & 15 - CountRows(
                                      Filter(
                                              Event1, Session.Value="Session 1"
                                       )
                             )
                                  

 

 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,432)