Forum Discussion
SUMX/PRODUCTX Not Returning Expected Result
Hi WNAGGE ,
According to your description, there are multiple tables in the dax expression.
1.you can check if there is a correct relationship between the tables, for more information about the relationship between the tables, you can refer to the documentation: Model relationships in Power BI Desktop - Power BI | Microsoft Learn.
2.on the other hand, the variable `_ kmintermediate` depends on the other metrics `[zzzz_numatrisk]` and `[zzzz_countdead]`. Ensure that these measures are calculated correctly in the current filtering context and do not return unexpected values.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. we can better understand the problem and help you.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi WNAGGE ,
According to your description, there are multiple tables in the dax expression.
1.you can check if there is a correct relationship between the tables, for more information about the relationship between the tables, you can refer to the documentation: Model relationships in Power BI Desktop - Power BI | Microsoft Learn.
2.on the other hand, the variable `_ kmintermediate` depends on the other metrics `[zzzz_numatrisk]` and `[zzzz_countdead]`. Ensure that these measures are calculated correctly in the current filtering context and do not return unexpected values.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. we can better understand the problem and help you.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for your help! I removed the relationship between 'Dim%Series'[Series] and FactPMBL[%DueCalc] which solved all my problems thankfully. I'd spent way too much time staring at this so I'm happy it was something simple.