Showing results for 
Search instead for 
Did you mean: 
julope Visitor

PRODUCTX not giving the correct number

Hi Community - I have been struggling for more than two days with this problem: 


I'm calcuting some efficiencies based on cumulative numbers using two tables (one with the data and the other one to run the cumulative numbers based on datetime of the event). Sometimes for a particular hour [datetime event], the operation doesn't have any data entry but cumulative is still showing since the're other operations that have data for the particular hour.


Now, when I use PRODUCTX the table is not calculting the numbers as is supposed. In the image below, regardless off the including more rows in the column "Measure" with more percentages, the numbers are the same ("AA" vs. "Measure")! For the measure column the result should be 81.69%... any thoughts why is this happening?


Community Support Team
Community Support Team

Re: PRODUCTX not giving the correct number

Hi @julope 


It seems you may use ALLSELECTED Function.Sample data and expected output will be helpful to provide an accurate solution.If you need further help,please follow the How to Get Your Question Answered Quickly to post your data and expected output.It would be better if you can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.




Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.