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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |