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 All,
I have one fact(sales) and 2 dimension tables(country & format). Both dimension tables are connected to fact with one to many relatioship, i have coulmn "weight" in sales table, country name in Country table & Format column in Format table.
Now i want to do the sum of weight, by country and format. i know i can do this in basic filter option and get the sum but i realy wanted to know the DAX for this. it is basically grouping by country column and format column from both dimension tables and get the sum of weight from sales table aginst those grouped rows.
Thanks in advance
Regards,
Vinay
@Anonymous wrote:
[Sum Of Weight] = SUM ( Sales[Weight] )
No, i have many rows , i want to get the sum of weight only for top3 by country by and by format .
Regards,
Vinay
Sure ! Will keep in in mind
and apologies for the half information
Regards,
vinay
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |