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.
Hello All,
I have the following tables,
The requirement is,
I need to filter the Fact table based products which are available in Dim. For example, I filter 5 products in Dim. I would like to have only those 5 products in Fact.
Is there any option to do this without having a calculated table?
Thanks,
Siva
Solved! Go to Solution.
Thanks for the response.
It works if we have a relationship between the tables and firing a query to apply the filter explicitly by adding the filter in Report.
Hi @SivaMani,
I made one sample for your reference.
1. Create a measure as below and filter the fact table by the measure. make the measure is 1.
Measure = IF(MAX('fact'[product]) in VALUES(Dim[product]),1,0)
For more details, please check the pbix as attaced.
Regards,
Frank
Thanks for the response.
It works if we have a relationship between the tables and firing a query to apply the filter explicitly by adding the filter in Report.
@SivaMani You mean, you want to filter the Fact table data when you use them in the visuals (as per the products available in Dim table). Could you please post a sample data before suggesting you something.
Proud to be a PBI Community Champion
Thanks for the reply @PattemManohar,
Yes. You're right. In my case, I'm not using any field in the visual.
I have a solution that merging to tables. It is costly in my case. So looking for a better way to do this.
I can't post any data here.
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |