Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am trying to replicate the above.
I have 2 tables which can be described as -
Table 1: Product name and share columns, there is also retailer & state columns (not shown above)
Table 2: Product name and competitive set ranked (not shown above)
Visualisation:
in a matrix, with drop-down filters on retailer, state & Name show (eg. Walmart, CA, Prod 1)
Name product, Name product share, comp 1, comp 1 share.
I have tried a number of formulas and so far most of my results for comp return (blank)
@Anonymous , Try new measures like
comp1 = maxx(filter(Table2, Table2[Comp1] = max(Table1[Name])),Table2[Comp1])
comp1 Share = maxx(filter(allselected(Table1), Table1[Comp1] = [comp1],Table1[Share])
Thanks for your reply.
The first formula (comp1) did not return a value (BLANK).
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |