Forum Discussion

Mihir2203's avatar
Mihir2203
Regular Visitor
2 years ago
Solved

Seperate filter for seperate columns in a table visual.

Hi Community Members,

 

I have a table visual with two columns Stock Quantity and Sales Quantity value. I need to filter this columns with two seperate filter.

 

Consider in a First filter, Month = Mar is selected 'Stocks (QTY)' should filter data as per Month of March

and in Second Filter, Month = Jul and Aug is selected 'Sales (value)' should filter data as per Month of july and August.

 

Please advice how we can achieve this.

Thanks in advance😀. 

 

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Mihir2203 , You can use two disconnected or atleast one disconnected date table

     

    //Date1 is independent Date table, Date is joined with Table

     

    Stock Quantity measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Stock Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

     

     

    //Date2 is independent Date table
    new measure =
    var _max = maxx(allselected(Date2),Date2[Date])
    var _min = minx(allselected(Date2),Date2[Date])
    return
    calculate( sum(Table[Sales Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

     

     

    Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

    Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    Mihir2203 , You can use two disconnected or atleast one disconnected date table

     

    //Date1 is independent Date table, Date is joined with Table

     

    Stock Quantity measure =
    var _max = maxx(allselected(Date1),Date1[Date])
    var _min = minx(allselected(Date1),Date1[Date])
    return
    calculate( sum(Table[Stock Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

     

     

    //Date2 is independent Date table
    new measure =
    var _max = maxx(allselected(Date2),Date2[Date])
    var _min = minx(allselected(Date2),Date2[Date])
    return
    calculate( sum(Table[Sales Quantity]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))

     

     

    Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

    Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg