Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
polimoda
Regular Visitor

Filters with 2 or more column

I'm new on PowerBI and I'm trying to undestand better how to use DAX.

I have the following table named say "Opportunity"

Id      Stage

1       0

2       1

3       0

4       2

5       0

6       1

7       1

8       0

9       1

10     2  

11     2

 

What I would like to obtain is a new table where for each distint value of Stage I have the count of row that are lower or equal to that value. In other words, I would like to obtain a table named "pipeline" with two colums like:

Col1=Distinct(Opportunity[Stage])

Col2=COUNTROWS ( filter(Opportunity; Opportunity[Stage] >= Col1 )

 

obtaing as a final result

Col1       Col2

0              11

1              7

2              3

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@polimoda

All you really need is this MEASURE

Measure =
CALCULATE (
    COUNTA ( Opportunity[Stage] ),
    FILTER (
        ALLSELECTED ( Opportunity ),
        Opportunity[Stage] >= MIN ( Opportunity[Stage] )
    )
)

Then create a Table Visualization like in the picture...

Filters with 2 or more column.png

Hope this helps.

Good Luck! Smiley Happy

 

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

@polimoda

All you really need is this MEASURE

Measure =
CALCULATE (
    COUNTA ( Opportunity[Stage] ),
    FILTER (
        ALLSELECTED ( Opportunity ),
        Opportunity[Stage] >= MIN ( Opportunity[Stage] )
    )
)

Then create a Table Visualization like in the picture...

Filters with 2 or more column.png

Hope this helps.

Good Luck! Smiley Happy

 

Thanks @Sean, after adapting it to my real data, the proposed solution seems to be working!

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.