Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ab Ab]

Hello, 

I have data table and data table contains item and country code. The item has duplicate entry and country code has unique entry against the item.

The same item has more than one country code or sometimes any one of them. (DMK or ADMK) 

Condition:

If same item has more than one country code then first priority is DMK and second priority is ADMK. If there is no duplicate entry then return the available country code according to the item. 

Result :

Now, I want to get the unique country code based on the above mentioned condition. 

I already created calculate column to get the desired result but I am looking for measure instead of calculated columns. 

I am using the below mentioned formulas to get the desired result but I want the same result by using measure instead of calculated columns. (Both of them giving same result but I am trying to apply the same login measure but it’s not working)

Result =

IF(

    ISEMPTY(

        FILTER(

        Data,Data[Item]=EARLIER(Data[Item])

        && Data[Country Code] = “DMK”)

        ),

        Data[Country Code],“DMK”)

Result1 =

VAR DMK =

CALCULATE(

    COUNTROWS(Data),

    FILTER(Data,

    Data[Item]=EARLIER(Data[Item])

    && Data[Country Code] = “DMK”)

)

RETURN

IF(DMK>0,“DMK”,[Country Code])

Also, I am attaching here the Power BI file for your reference. Could you please help me.

https://www.dropbox.com/s/y1q6e4w0sndhnd7/Unique%20count%20based%20on%20the%20text%20-%2023-02-2023.pbix?dl=0

——————————
Ab Ab
Engineering
——————————

[Vilmar Santos]

Veja se ajuda

zResult = 
VAR Var1 =
    SELECTEDVALUE ( Data[Item] )
RETURN
    IF (
        ISEMPTY ( FILTER ( ALL ( Data ), [Item] = Var1 && [Country Code] = "DMK" ) ),
        SELECTEDVALUE ( Data[Country Code] ),
        "DMK"
    )

zResult1 = 
VAR Var1 =
    SELECTEDVALUE ( Data[Item] )
VAR DMK =
    CALCULATE (
        COUNTROWS ( Data ),
        FILTER ( ALL ( Data ), [Item] = Var1 && [Country Code] = "DMK" )
    )
RETURN
    IF ( DMK > 0, "DMK", SELECTEDVALUE ( Data[Country Code] ) )

——————————
Vilmar Santos
——————————
——————————————-