Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 30 | |
| 28 | |
| 24 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 46 | |
| 32 | |
| 17 | |
| 17 | |
| 16 |