How to Group by Category

[bbwong]

Hi,

Needing assistance to categories IDs by service combinations:

With thanks,

[bbwong]

Thanks for the quick response. Not sure if I understand the measure provided.

The Service Name is actually a string and I need to identify if the string contains the text: standard or high, to then have the ability to roll up and categorized this at the ID level.

[v-shex-msft]

Hi @bbwong,

Can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[bbwong · Accepted solution]

Hi,

I was able to resolve my query by using the measure on this post:

 https://community.powerbi.com/t5/Desktop/DAX-to-flag-Customer-as-Yes-No-or-Both-based-on-purchase-da...

[mahoneypat]

You can create a column in the query editor that just has Standard, High, etc. (text after delimiter of "= " for example), and then use a measure like this.

NewMeasure = CONCATENATEX(DISTINCT(Table[ServiceName]), Table[ServiceName], "/")

Pat