Forum Discussion
Sum Values within a criteria
Hi bcassilhas ,
If I have misunderstood your meaning before, please provide your pbix file without privacy information and more details with your desired output.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Polly, thank you for the answer!
Maybe i wasnt too much clear, but i think i couldnt get the output i wanted. The lowest price column needs to be matching by id. Below, theres a part of the dataset with the 2 new columns. The arrows refers to Product ID, Our Price and Competidor Price, respectively. The new calculated columns aren't returning any price value for this ID (256).
I want to build a matrix like this (sum lowest prices of products of each category):
| Category | Our Price | Competidor Price |
| Drinks | $3500 | $3400 |
| X | $1200 | $1300 |
| Y | $2000 | $2200 |
I didn't understood too much the category slicer that you put to change the values. I have Date, Store and Competidor Slicers on my report, and the matrix above needs to filter according to these criterias.
Thank you! 🙂
Hi bcassilhas ,
If I have misunderstood your meaning before, please provide your pbix file without privacy information and more details with your desired output.
How to Get Your Question Answered Quickly
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.