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,...
  • amitchandak's avatar
    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