Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
15 | |
14 | |
14 | |
9 |