Forum Discussion

mrothschild's avatar
mrothschild
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Deflattening Text for DistinctCounts - bad post - ignore

 

**Update** - I used the following New Measure and it worked for my more complex version of the table, but until I have a slicer for projects, don't think it would work specifically here: 

 

New Measure = calculate(DISTINCTCOUNT(Sheet1[Project]),groupby(Sheet1,Sheet1[Model]))
 
Need Help

2 Replies

    • mrothschild's avatar
      mrothschild
      Icon for Continued Contributor rankContinued Contributor
      7 years ago

      Sorry it was a poor effort in trying to simplify my data relative to the actual data I was working with.  I'm deleting the post.