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.
Hi - I have a single value card in a report - if I have multiple orders when I select a customer it by default displays the first one. I'd like the value on that card to count the number of orders and if it's greater than 1 to display 'Multiple orders' and if there is only 1 order matching the filters to display the order number.
I have
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
Measure =
IF (
COUNT ( Order[OrderNumber] ) > 1,
"Multiple Orders",
MAX ( Order[OrderNumber] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Here is an example on how to do this:
Data:
Dax:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Thanks to Both of you for helping out - much appreciated 😄
Hi,
Here is an example on how to do this:
Data:
Dax:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
I am not sure how your datamodel looks like, but please try the below whether it suits your requirement.
Measure =
IF (
COUNT ( Order[OrderNumber] ) > 1,
"Multiple Orders",
MAX ( Order[OrderNumber] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
45 | |
26 | |
22 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |