Want to group Records under $10m, and show details for those over.

[Anonymous]

Hi, everyone.

I am building a report and want to group all values below a certain threshold ($10m) and show the details for records over that value. So something like this:

Record	Value
Opportunity 1	$100,000,000
Opportunity 2	$250,000,000
All Opps under $10m	$35,000,000
Total	$385,000,000

I could use a summary table to do this, but I am wondering if there is another way to do this without creating a new DAX Table? Any thoughts would be most welcome.

Thanks, Scott

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

So you don't want a new table? How about creating a column on raw table then create a visual as below?

Column = IF('Table'[Value]>=100000000,'Table'[Record],"All Opps under $10m")

 

Best Regards,

Jay

[harshnathani]

Hi @Anonymous ,

You can try something like this 

https://www.youtube.com/watch?v=iH3gW_vy69o

Regards,

Harsh Nathani

[Anonymous]

Hi, @harshnathani. That is close, but I want to show the ungrouped records for all but one of the groups. Using that example, I want to show the records for the high and medium margin groups, and I want to show just the aggregate group for the low margin, I could be wrong, but I don't think that dax pattern allows some data to be grouped but other to not be grouped. 

Thanks,

Scott