Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I need to generate multiple reports from different tables. The common columns are Name,Surname and, Date. There are others as well.
I have created follwoing measure for to show in card visualization based on selection.
| M_Name_Card = IF(HASONEVALUE(TABLE1[Name]),SELECTEDVALUE(TABLE1[Name]),"Multiple") |
| M_Surname_Card = IF(HASONEVALUE(TABLE1[Surname]),SELECTEDVALUE(TABLE1[Surname]),"Multiple") |
| M_Date = FORMAT(TABLE1[Date],"Mmm'YY") |
| M_Date_Card = IF(HASONEVALUE(TABLE1[Date]),SELECTEDVALUE(TABLE1[M_Date]),"Multiple") |
I need to use the same measures with other Tables, Like Table 2, Table3... in different reports.
How can I use Table name as variable and use?
Gb
Hi @gaurangb,
Based on my research, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
| User | Count |
|---|---|
| 51 | |
| 38 | |
| 33 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 59 | |
| 36 | |
| 35 |