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.
My problem is as it follows: I have 2 tables, the first one has the amount of products per date and the company ID from where that product is; the second one has the company ID and the company name. In order to calculate the amount of products that each company have in the last date of the selected month I wrote the Dax code as shown below:
When I put the Company Name as a row header in a matrix visual I am getting the wrong total. I've already tried the SUMMARIZE+SUMX, the IF+HASONFILTER and the SUMX methods but none of these actually worked. The DAX code of my attempts are listed below:
Solved! Go to Solution.
Hi @Gekko1 ,
If your goal is to calculate the amount of products that each company have in the last date of the selected month, please try following steps:
This is my test table:
Create a new column:
Month = FORMAT([Date],"mmmm")
Try following measure:
Measure = CALCULATE(
SUM('Table'[Amount]),
FILTER('Table','Table'[Month] = SELECTEDVALUE('Table'[Month]) &&
'Table'[Company ID] = SELECTEDVALUE('Table'[Company ID]) &&
'Table'[Date] = MAX('Table'[Date]))
)
Is this the result you want?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Gekko1 ,
If your goal is to calculate the amount of products that each company have in the last date of the selected month, please try following steps:
This is my test table:
Create a new column:
Month = FORMAT([Date],"mmmm")
Try following measure:
Measure = CALCULATE(
SUM('Table'[Amount]),
FILTER('Table','Table'[Month] = SELECTEDVALUE('Table'[Month]) &&
'Table'[Company ID] = SELECTEDVALUE('Table'[Company ID]) &&
'Table'[Date] = MAX('Table'[Date]))
)
Is this the result you want?
Best regards,
Yadong Fang
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |