Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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))
Thank you very much!!! Sorry, I made you work a bit
@San_eve , Please find the attached file
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 , 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!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |