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.
Hi,
I'm totally new to Power BI. I know how to load data into it and how to manage relationships between tables, but that's about it.
I have one fact table which has all sales events, including price and customer id. Then I have a dimension table for customers, which has information including the number of children in the household.
I would need to figure out, based on the data, what was the total amount of sales for customers with 4 or 5 children, in 2013.
How would I go about doing this? I'm totally lost.
Solved! Go to Solution.
Hi @Anonymous
I make a simple example
create realtionships as below
create measures in "fact table"
Measure = IF ( MAX ( [year] ) = 2013 && ( MAX ( 'dimension table'[the number of children] ) = 4 || MAX ( 'dimension table'[the number of children] ) = 5 ), 1, 0 ) Measure 2 = CALCULATE(SUM('fact table'[price]),FILTER(ALL('fact table'),[Measure]=1))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
I make a simple example
create realtionships as below
create measures in "fact table"
Measure = IF ( MAX ( [year] ) = 2013 && ( MAX ( 'dimension table'[the number of children] ) = 4 || MAX ( 'dimension table'[the number of children] ) = 5 ), 1, 0 ) Measure 2 = CALCULATE(SUM('fact table'[price]),FILTER(ALL('fact table'),[Measure]=1))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |