unable to update row data - conditional column

Question

Hi,&nbsp;&nbsp;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,&nbsp; if one entry for that has issue. all other logic remains same.&nbsp;for below data, id 2005 - has 4 entries - 1 issue , 3 good. need to show all 4 as issue in that case.&nbsp;tried several formulas but didn't work. wondering if we can achieve this in powerbi desktop ? this is my first time with it.&nbsp;&nbsp;date&nbsp;&nbsp;IDcategoryanswerfollowupskippedCustomgoodFupSkipIssue5/19/2020200612390000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/2020200612380000001TRUEFalseFup&nbsp;1&nbsp;&nbsp;5/19/2020200612390000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/2020200510490000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/2020200510490000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/2020200510490000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/2020200510480000001FalseFalseI&nbsp;&nbsp;&nbsp;15/19/202020055690000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/202020055690000000FalseFalseG1&nbsp;&nbsp;&nbsp;5/19/202020055680000001TrueFalseFup&nbsp;1&nbsp;&nbsp;5/19/20202005280000001TrueFalseFup&nbsp;1&nbsp;&nbsp;5/19/20202005280000001TrueFalseFup&nbsp;1&nbsp;&nbsp;

greg_deckler · Answer

jpat1234&nbsp;- So what are we looking at? Is that your expected output? If so, what does the source data look like?
&nbsp;
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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

mahoneypat · Answer

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

v-xicai · Answer

Hi jpat1234&nbsp;,
&nbsp;
You may create measure like DAX below.
&nbsp;
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])&amp;&amp; Table1[Issue] &lt;&gt; BLANK())) &gt;1, d ,0)
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
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.
&nbsp;

jpat1234 · Answer

1) for catagory 104 in my table - want to change row level data on issues column2) for catagory 104 ,&nbsp; if one row has issue or follow up then all rows for should be displayed as issue/followup for same id.&nbsp;3) all other data remains the same.&nbsp;&nbsp;My data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IDcategoryanswerfollowupskippedgoodFupSkipIssue200510490000000FalseFalse1&nbsp;&nbsp;&nbsp;200510490000000FalseFalse1&nbsp;&nbsp;&nbsp;200510490000000FalseFalse1&nbsp;&nbsp;&nbsp;200510480000001FalseFalse&nbsp;&nbsp;&nbsp;120055680000001TrueFalse&nbsp;1&nbsp;&nbsp;200612380000001FALSEFalse&nbsp;&nbsp;&nbsp;1200612390000000FalseFalse1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Expected data&nbsp;(want to change the way issue column looks in the data table)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IDcategoryanswerfollowupskippedgoodFupSkipIssue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200510490000000FalseFalse&nbsp;&nbsp;&nbsp;1200510490000000FalseFalse&nbsp;&nbsp;&nbsp;1200510490000000FalseFalse&nbsp;&nbsp;&nbsp;1200510480000001FalseFalse&nbsp;&nbsp;&nbsp;120055680000001TrueFalse&nbsp;1&nbsp;&nbsp;200612380000001FALSEFalse&nbsp;&nbsp;&nbsp;1200612390000000FalseFalse1&nbsp;&nbsp;&nbsp;

Forum Discussion

unable to update row data - conditional column

4 Replies

Related content

Unable to update gateway

Conditional row update

Unable to update schema in semantic model

App not updating

Dataflow OAuth Connection Error – Unable to Update API Login

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

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