Forum Discussion
unable to update row data - conditional column
Hi, I am trying to update conditional column row data based on calculation. below is my sample data. need to display certain catagories data as issue for all entries fort he same id, if one ent...
Please try this expression in your calculated column. I called the table 'Issues'.
ThisIDHasIssue =
VAR issuesthisID =
CALCULATE (
COUNTROWS ( Issues ),
ALLEXCEPT ( Issues, Issues[ ID] ),
Issues[Issue] = 1
)
RETURN
IF ( issuesthisID >= 1, 1, 0 )
VAR issuesthisID =
CALCULATE (
COUNTROWS ( Issues ),
ALLEXCEPT ( Issues, Issues[ ID] ),
Issues[Issue] = 1
)
RETURN
IF ( issuesthisID >= 1, 1, 0 )
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat