Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables (Table A and Table B) which don't have any relationship.
I want to dispaly the strike rate for the Brokers in each club year from table 2 against the Brokers who comes under the top 20 % of Prorata Net Premium from table 1 in each club year.
Brokers Names are same on both the table.
Kindly help me on this.
Kind Regards
Amit Kumar
Hi @a4 ,
Could you kindly share some sample data and the expected result to have a clear understanding of your question? It can help me do some tests.
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
Best Regards,
Yuna
I have already shared a screenshot of the sample data. Please refer my first post.
@a4 , Try a measure like
measure =
var _bro = Filter(
ADDCOLUMNS(summarize(Table2,Table2[Broker],"Strike rate", Sum(Table2[Strike rate])),"_Top20"
IF( ISBLANK( [Strike rate] ),
BLANK(),
IF( RANKX( ALL( Table2[Broker] ), [Strike rate], , DESC ) < ( CALCULATE( [Strike rate], ALL( Table2[Broker] ) ) * 0.2 ),
[Strike rate],
BLANK() ) )),not(isblank([_Top20])))
return
calculate(counrows(Table1), Table1[Broker] in _bro)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |