Forum Discussion

jpat1234's avatar
jpat1234
New Member
6 years ago

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...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi jpat1234 ,

 

You may create measure like DAX below.

 

CountIssue=

VAR d= CALCULATE(COUNT(Table1[category]),FILTER(ALLSELECTED(Table1), Table1[ID] =MAX(Table1[ID])))

RETURN

IF(COUNTROWS(FILTER(Table1, Table1[ID]=MAX(Table1[ID])&& Table1[Issue] <> BLANK())) >1, d ,0)

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.