Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table below that I only want to show duplicates when the estimate # is the same. How can this be done with an expression.
Thanks/Mike
Estimate Number | Estimate Date | Job ID | |
60-3 | 3/28/2022 | 1535 | |
3 | 4/3/2022 | -- | |
10 | 4/3/2022 | -- | |
11 | 12/31/2021 | 1478 | |
15 | 1/3/2022 | 1477 | |
22 | 4/2/2022 | -- | |
24 | 1/3/2022 | 1491 | |
25 | 1/4/2022 | 1468 | |
25 | 5/10/2022 | 1554 | |
26 | 7/20/2021 | 1507 | |
27 | 1/3/2022 | -- | |
28 | 1/3/2022 | -- |
The results should be.
Estimate Number | Estimate Date | Job ID |
25 | 1/4/2022 | 1468 |
25 | 5/10/2022 | 1554 |
You need to somehow do a logical test calculating how many of each estimate number.
What if you create an measure like this
if(count(total <[Estimate Number]> [Estimate Number])>1, true(), false())
I created a measure using that expression and it show all of them as "true".
if(count(total <[Estimate Number]> [Estimate Number])>1, true(), false())
Maybe they are true? What happens if you use this expression
count(total <[Estimate Number]> [Estimate Number])
and/or
count( [Estimate Number])
Do you get the numbers you expect?
I found code out there that allowed me to check the count and it works. Thanks for the followup.
=aggr(
only({<[Estimate number]=>}[Estimate number])
& repeat(chr(160),65)
&num(
count({<[Estimate number]=>}DISTINCT [Job ID])
,'###0')
,[Estimate number])