cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Multiple filters to countrows into new table

I have multiple columns in a table that I would like to filter and count.

 

table.png

 

I would like the new table to show only 'Open' Status and count the TRUE fields
The final table(s) would look like:

 

(1 Table)

 

Severity |<1MTH|>1MTH|.....

Major     |     2      |    0

Minor     |     9      |    0

 

or

 

(2Tables)

 

'Open-Major Table'

 

<1MTH|>1MTH|.....

     3      |    0

 

and

 

'Open-Minor Table'

 

<1MTH|>1MTH|.....

    9      |    0

 

How do I go about doing so? Thank you!~

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Multiple filters to countrows into new table

Hi raddy,

 

Click query editor, filter status column by "Open":

1.PNG 

Click Transform-> Pivot Columns as below:

2.PNG3.PNG  

 

Hope it's helpful to you.

 

Jimmy Tao

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Multiple filters to countrows into new table

Hi raddy,

 

Click query editor, filter status column by "Open":

1.PNG 

Click Transform-> Pivot Columns as below:

2.PNG3.PNG  

 

Hope it's helpful to you.

 

Jimmy Tao

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors