Hello Smart Folk!
I have a large table of data where multiple clients are associated to the same proposal.
I would like to calculate the sum of "GP" of "Sold" and "Almost Sold" but not include duplicates of the same proposal or "No Sale".
In the sample data below, the total should be $11,000 (2800+2800+2200+3200).
I tried creating an intermediate measure with:
DistinctSold = MAXX(DISTINCT('Table'[Proposal]),SUM('Table'[GP]))
But I get the error "Function 'MAXX' is not supported in this context in DirectQuery mode."
Any ideas?
See sample table:
| Client | Proposal | GP | Status |
| Bob | abc | $2,800.00 | Sold |
| Joe | abc | $2,800.00 | Sold |
| Mary | bcd | $2,800.00 | Sold |
| Sue | cde | $2,200.00 | Almost Sold |
| Ellen | cde | $2,200.00 | Almost Sold |
| Frank | cde | $2,200.00 | Almost Sold |
| Tim | def | $2,500.00 | No Sale |
| Bill | def | $2,500.00 | No Sale |
| Jim | efg | $3,200.00 | Sold |
