Filters with 2 or more column

Question

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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Stage1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp; 2 &nbsp;11&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;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] &gt;= Col1 )&nbsp;obtaing as a final resultCol1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Col20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3

sean · Accepted Answer

polimodaAll you really need is this MEASUREMeasure =
CALCULATE (
    COUNTA ( Opportunity[Stage] ),
    FILTER (
        ALLSELECTED ( Opportunity ),
        Opportunity[Stage] &gt;= MIN ( Opportunity[Stage] )
    )
)Then create a Table Visualization like in the picture...Hope this helps.Good Luck! :smileyhappy:&nbsp;

Forum Discussion

Filters with 2 or more column

2 Replies

Related content

Slicer for filtering several columns

Apply data to all rows in a filtered column

Filter

odata Report Level Filters Multiple Filters Same Column

Adding filters to a calculated column