Can "Measure" create a new field?

[KH_Mike]

Hi All,

I am new in PBI and right now, I have a report which linked to the DataSet but I am not allowed to create new column. I try below formula by creating new Measure but not success.

The data is as follow, I have one column call Grouping which have five possible recrods which are AAA, BBB, CCC, DDD and EEE. How I would like to create a table and sum the potential value but before that I want to group AAA & BBB to show it as "High Potential".

I try something like below but not success. May I know how to write?

If(and([Grouping] = "AAA", [Grouping] = "BBB"), "High Potential", [Grouping])

[Jihwan_Kim]

Hi, @KH_Mike 

Please correct me if I wrongly understood your question.

I don't know know your model well, but I am not sure if [Grouping] could have a two-value-at-the-same-time.

Please try to replace it with OR function.

If(OR([Grouping] = "AAA", [Grouping] = "BBB"), "High Potential", [Grouping])

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[KH_Mike]

Hi @Jihwan_Kim ,

Thank you for your support but I still can't acheive what I want. Below image is for your reference. Please note that in the real data, I am not allowed to create new column. That mean I can only create new "Measure". Thank you.

[Jihwan_Kim]

Hi, @KH_Mike 

Please try the below.

Test Measure =
IF (
OR (
SELECTEDVALUE ( Sheet1[Grouping] ) = "AAA",
SELECTEDVALUE ( Sheet1[Grouping] ) = "BBB"
),
"High Potential",
SELECTEDVALUE ( Sheet1[Grouping] )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[KH_Mike]

Hi @Jihwan_Kim 

Still not workable. This will only show if I select the [Grouping].

[Jihwan_Kim]

Addition to my last reply,

try the below measure, and pull the measure and the Grouping column into the Table Visualization.

Test Measure =
IF (
OR (
SELECTEDVALUE ( Sheet1[Grouping] ) = "AAA",
SELECTEDVALUE ( Sheet1[Grouping] ) = "BBB"
),
"High Potential",
sum ( Sheet1[Value])
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Jihwan_Kim]

Hi,

I am confused.

I think I missed something from your explanation about what you want to achieve.

I do not understand why you are pulling the measure and value column.

Can you try to pull the Grouping Column and the measure into the Table Visualization?

Or, share your pbix file's link please, then I can try to look into it to come up with a more accurate solution.

[KH_Mike]

Hi @Jihwan_Kim 

Because IT side put the data to PBI Premiun. When we connect to that database, the "Data" tab is not available for us to create "Column". I can either request IT to add that field or use "Measure" to acheive it. Thank you.