Forum Discussion

TJK's avatar
TJK
Helper I
2 years ago
Solved

Group By Calculated Column

How would I create the "Is Loyal v2" column in the Table View using DAX based on the first two columns? I want the outcome to equal "No" for all rows if there is a row that equals "No" for the ID in ...
calculated column
DAX
Group By
  • jgeddes's avatar
    jgeddes
    2 years ago

    As a calculated column...

    Is Loyal v2 = 
CALCULATE(
    MIN([Is Loyal]),
    ALLEXCEPT(loyalTable, loyalTable[ID])
)
TJK's avatar
TJK
Helper I
2 years ago

Hi ahadkarimi ,

 

You're formula is giving me the same result as the "Is Loyal" column. It's only showing "No" when "Is Loyal" is equal to "No".  I would like it to show "No" for all rows for the given ID.

ahadkarimi's avatar
ahadkarimi
Solution Specialist
2 years ago

TJK 

Is Loyal v2 = 
IF(
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[ID] = EARLIER('Table'[ID]),
        'Table'[Is Loyal] = "No"
    ) > 0,
    "No",
    "Yes"
)