topic Re: Can "Measure" create a new field? in DAX Commands and Tips

Can "Measure" create a new field?

KH_Mike — Thu, 15 Apr 2021 02:25:41 GMT

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])

Re: Can "Measure" create a new field?

Jihwan_Kim — Thu, 15 Apr 2021 02:53:14 GMT

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/

Re: Can "Measure" create a new field?

KH_Mike — Thu, 15 Apr 2021 03:21:33 GMT

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.

Re: Can "Measure" create a new field?

Jihwan_Kim — Thu, 15 Apr 2021 03:41:34 GMT

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/

Re: Can "Measure" create a new field?

KH_Mike — Thu, 15 Apr 2021 04:05:10 GMT

Hi Jihwan_Kim

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

Re: Can "Measure" create a new field?

Jihwan_Kim — Thu, 15 Apr 2021 04:28:27 GMT

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.

Re: Can "Measure" create a new field?

Jihwan_Kim — Thu, 15 Apr 2021 04:39:34 GMT

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/

Re: Can "Measure" create a new field?

KH_Mike — Thu, 15 Apr 2021 06:51:24 GMT

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.