Use SWITCH Function without aggregating the field

[KathrynAnderson]

I need to creat a new measure that will group like products together. See the table below, where the New_Measure column is what I want to create.

I cannot create a new column because I have to use  Live Connection.  I've tried using the SWITCH function, but it requies an aggregate on the Product_Code, which breaks the results if the Product_Code isn't part of the visual.  Does anyone know of a way to basically create a custom grouping with a Live Connection?

Product_Code	Sales_Amount	New_Measure
ABC	$100	Painting
BCD	$500	Painting
CCD	$200	Painting
EEC	$300	Maintenance
BDS	$700	Maintenace

[mwegener]

Hi @KathrynAnderson ,

take a look at this.

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[mwegener · Accepted solution]

Hi @KathrynAnderson ,

try this.

New_Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[Product_Code] ),
    "ABC", "Painting",
    "BCD", "Painting",
    "BDS", "Maintenance",
    "CCD", "Painting",
    "EEC", "Maintenance"
)

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.