Table Visual based on selected value from the slicer

[San_eve]

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 select A in the slicer, I should get below output

As A and C belong to same Brand Type. I am new to Power BI and unable to find a solution to it

Thanks for any help

[San_eve]

Thank you very much!!! Sorry, I made you work a bit

[amitchandak]

@San_eve , Please find the attached file

[San_eve]

Thank you! I am getting errors in Summarize. Can you explain the logic here? Thanks again

[amitchandak]

@San_eve , Please share the error,

Based on independent we are getting brand, By passing those brand I and trying getting brand_type, The same brand type I am trying use to get amount

[amitchandak · Accepted solution]

@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]

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!