This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Dear Friends,
I am using IPL Crikcet Data set which can be found on
https://www.kaggle.com/manasgarg/ipl/data
I have created calculaed Measure to get the winner Team & would like to display logo of winner team. I have created separate table with Team Name & Team URL Mapping. Kindly help me on How to match team name with winner team & display the image. Thanks.
Solved! Go to Solution.
I used below function where team Logo is the URL field & team name is indicates
Winner Filter = CALCULATE(count(Logo[Team Logo]),FILTER(Logo,logo[Team_Name]=[IPL_Winner]))
Hi @ajinkya1907,
I think you can take a look at below link who mentioned about similar requirement.
Regards,
Xiaoxin Sheng
Thanks for your help @Anonymous
I used below function where team Logo is the URL field & team name is indicates
Winner Filter = CALCULATE(count(Logo[Team Logo]),FILTER(Logo,logo[Team_Name]=[IPL_Winner]))
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 22 | |
| 20 |