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.
I have a dim and fact table connected via one to many relationship.
Dim table : Country with targets
Country | Target |
IN | 200000 |
UK | 500000 |
US | 1000000 |
Fact table: Actual transactions
Date | Country | Sales |
1/2/2023 | IN | 4567 |
4/5/2023 | US | 56789 |
3/4/2022 | US | 43456 |
5/6/2021 | UK | 125678 |
Relationship : Country(dim) to Country (fact)
Cardinality : one to many
When I dragged Country from fact and target from dim table, with Don't summarize it shows correct values. (implicit measure)
But when i created an explicit measure for Target = SUM (Country[Target]) and dragged into the same table it show total values repeated for each rows.
Default aggregation for both value columns are "Don't summarize"
So I'm confused, how that works.
Can anyone help me to understand this is much appreciated.
Also I have a question regarding how to model dim tables with target values and connect to a fact table with a project having RLS and page level security. Please share the best practises.
@jithinrg ,Somehow I see same values
In this country, should always be used from Dim table.
Or you have use meausre like
Sumx(Summarize(Target, Target[Country], Target[Target]), [Target])
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |