Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |