Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi everyone,
I need the valuable help of this fantastic community! I hope someone can explain me the reason why the same formula (SELECTCOLUMNS) applied to two IDENTICAL tables produces very different outcomes!
Picture 'desired outcome' shows what I want to achieve.
It is very important to me have this point clarified because I need SELECTCOLUMNS behaving as per example 1 that is:
- populate 'cost 20' column with all the records of t_SCRP[Cost] filtered by year 2020
- populate 'cost 21' column with all the records of t_SCRP[Cost] filtered by year 2021
- populate 'cost 22' column with all the records of t_SCRP[Cost] filtered by year 2022
- and so on, for upcoming years...
desired outcome
weird behaviour
Thanks and best regards!
Solved! Go to Solution.
Thanks HotChilli, you are right, definitely the problem is into relationships!
Looking more in deep in my file, I also found that other tables giving same 'issue' have a 1:1 relationship with date table while others with *:1 relationship work well. Changing them to many-to-one (and cross filter direction set to 'single') has fixed the issue.
Yes i got the file, thanks.
The problem is one of the source tables has a relationship with the date table and one does not. I was going to take a guess that it was relationship based since getting all the same values for a measure usually indicates this.
Thanks HotChilli, you are right, definitely the problem is into relationships!
Looking more in deep in my file, I also found that other tables giving same 'issue' have a 1:1 relationship with date table while others with *:1 relationship work well. Changing them to many-to-one (and cross filter direction set to 'single') has fixed the issue.
Can you provide a sample pbix please?
Hi, here the link to download the file (please let me know if this works)
https://www.dropbox.com/sh/3e2z9adan0z1fv6/AADMORm0Fx0bX4YMMc4UZrgPa?dl=0
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!