Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hey!
I need that the tables 2 and 3 just present data after I selected one row at the table 1. They are three diferent tables at model. Table 1 is a fact table and the relation with table 2 and 3 are 1-to-many.
I tried to:
- create a measure to find when table 1 is filtered to apply that measure at tables 2 and 3; and,
- create a virtual table.
However, these two solutions did no work as well.
Can you help me?
Solved! Go to Solution.
Hi @gregoliveira ,
Please try like:
Measure = IF(ISFILTERED('FactTable'[Column1]),1)
and then use it as table2, table3's filter.
result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @gregoliveira ,
Please try like:
Measure = IF(ISFILTERED('FactTable'[Column1]),1)
and then use it as table2, table3's filter.
result:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Perfect! Thanks a lot! I tried something like this, but as a newbie I forgot something to finish well! 🙂
Thanks again!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.