Forum Discussion

San_eve's avatar
San_eve
Regular Visitor
4 years ago
Solved

Table Visual based on selected value from the slicer

Hi,   I have a table just like below table.   I have a slicer for brand. When I select any brand on the slicer I should get the table visual based on the Brandtype.   Example:   If I se...
  • amitchandak's avatar
    amitchandak
    4 years ago

    San_eve , Create an independent table with distinct brand 

     

    brand = distinct(Table[brand])

     

    then create a measure like

    measure =

    var _tab = summarize(filter(Table, Table[Brand] in values(brand[brand]) ), Table[brand_type])

    return

    calculate(Sum(Table[Sales]), filter(Table, Table[brand_type] in _tab))