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...
Need Help
  • 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))

amitchandak's avatar
amitchandak
Super User
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))

San_eve's avatar
San_eve
Regular Visitor
4 years ago

Hi Again! Is there a way to limit number of rows in table visual? My viusal is dynamic and for some brands the slide bar is appearing on the screen. Thanks for your help!