unable to update row data - conditional column

[jpat1234]

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 entry for that has issue. all other logic remains same. 

for below data, id 2005 - has 4 entries - 1 issue , 3 good. need to show all 4 as issue in that case. 

tried several formulas but didn't work. wondering if we can achieve this in powerbi desktop ? this is my first time with it. 

date	ID	category	answer	followup	skipped	Custom	good	Fup	Skip	Issue
5/19/2020	2006	123	90000000	False	False	G	1
5/19/2020	2006	123	80000001	TRUE	False	Fup		1
5/19/2020	2006	123	90000000	False	False	G	1
5/19/2020	2005	104	90000000	False	False	G	1
5/19/2020	2005	104	90000000	False	False	G	1
5/19/2020	2005	104	90000000	False	False	G	1
5/19/2020	2005	104	80000001	False	False	I				1
5/19/2020	2005	56	90000000	False	False	G	1
5/19/2020	2005	56	90000000	False	False	G	1
5/19/2020	2005	56	80000001	True	False	Fup		1
5/19/2020	2005	2	80000001	True	False	Fup		1
5/19/2020	2005	2	80000001	True	False	Fup		1

[v-xicai]

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.

[mahoneypat]

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 )

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Greg_Deckler]

@jpat1234 - So what are we looking at? Is that your expected output? If so, what does the source data look like?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[jpat1234]

1) for catagory 104 in my table - want to change row level data on issues column

2) for catagory 104 ,  if one row has issue or follow up then all rows for should be displayed as issue/followup for same id. 

3) all other data remains the same. 

My data
ID	category	answer	followup	skipped	good	Fup	Skip	Issue
2005	104	90000000	False	False	1
2005	104	90000000	False	False	1
2005	104	90000000	False	False	1
2005	104	80000001	False	False				1
2005	56	80000001	True	False		1
2006	123	80000001	FALSE	False				1
2006	123	90000000	False	False	1
Expected data		(want to change the way issue column looks in the data table)
ID	category	answer	followup	skipped	good	Fup	Skip	Issue
2005	104	90000000	False	False				1
2005	104	90000000	False	False				1
2005	104	90000000	False	False				1
2005	104	80000001	False	False				1
2005	56	80000001	True	False		1
2006	123	80000001	FALSE	False				1
2006	123	90000000	False	False	1