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! 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