Forum Discussion
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 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 , 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))
6 Replies
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))
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!
Thank you! I am getting errors in Summarize. Can you explain the logic here? Thanks again
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
San_eve , Please find the attached file
Thank you very much!!! Sorry, I made you work a bit
