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?
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.