Forum Discussion
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...
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))
Thank you very much!!! Sorry, I made you work a bit