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.
Hey guys,
I appreciate the help. I want to create an expression that calculates the average price of different products filtered by a unique identifier in this case a contract number.
This is my data:
This is the expression I am working with but it is not applying the Contract filter and instead it is using the total average on the data.
Solved! Go to Solution.
Hi, @HenriqueReis Thanks for the reply. So I am using trying to view this information as a value in a matrix that was already created. I was playing with the model relationships and I fixed the issue I was having. I appreciate your help. The above expression was correct.
Hi, @HenriqueReis Thanks for the reply. So I am using trying to view this information as a value in a matrix that was already created. I was playing with the model relationships and I fixed the issue I was having. I appreciate your help. The above expression was correct.
That's great! haha
Regards!
Hi,
It's simple:
Create a measure like this:
Measure = average(All contracts advanced[price])
Then put your meassure in a card
And create a slicer and put your contract
Select just the contracts you want and then I think it's going to work
Regards!
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 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |