Forum Discussion

TJK's avatar
TJK
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
2 years ago

As a calculated column...

Is Loyal v2 = 
CALCULATE(
    MIN([Is Loyal]),
    ALLEXCEPT(loyalTable, loyalTable[ID])
)