Forum Discussion
Issue in countrows
Hi all i have a table where is have to consider a "Partnrer" project if it is already an "Owner". Please see the data below
If Segment is 71 then it is Owner else Partner
| PRJ | Segment | Owner/Partnrer |
| A | 71 | Owner |
| A | 1 | Partner |
| A | 2 | Partner |
| B | 3 | Partner |
| C | 71 | Owner |
| C | 13 | Partner |
| D | 71 | Owner |
I need to consider only A,C because its Partner has owner.
I created countrows(Filter(table,earlier(prj)=prj) but not working properly.
amitchandak
harshagraj , Try if this can help
new column =
var _cnt = countx(filter(Table, [PRJ] =earlier([PRJ]) && [Segment] =71),[PRJ])
var _cnt1 = countx(filter(Table, [PRJ] =earlier([Owner/Partnrer]) && [Segment] = "Partner"),[PRJ])
return
if(not(isblank(_cnt)) && not(isblank(_cnt1)) , "Owner", "Other")
5 Replies
harshagraj , Try a new column like
new column =
var _cnt = countx(filter(Table, [PRJ] =earlier([PRJ]) && [Segment] =71),[PRJ])
return
if(isblank(_cnt),[Segment], "Owner")Hi amitchandak thanks for the reply but it is not giving me desired solution, in the below ss highlighted ones doesnt have a partner at all.
Partner =
VAR cnt =
COUNTX (
FILTER (
'OS Sales_Project_WonLost_VW',
'OS Sales_Project_WonLost_VW'[SF_Number]
= EARLIER ( 'OS Sales_Project_WonLost_VW'[SF_Number] )
&& 'OS Sales_Project_WonLost_VW'[Segment_code] = "0071"
),
'OS Sales_Project_WonLost_VW'[SF_Number]
)
RETURN
IF ( ISBLANK ( cnt ), 'OS Sales_Project_WonLost_VW'[Segment_code], "Owner" )harshagraj , Try if this can help
new column =
var _cnt = countx(filter(Table, [PRJ] =earlier([PRJ]) && [Segment] =71),[PRJ])
var _cnt1 = countx(filter(Table, [PRJ] =earlier([Owner/Partnrer]) && [Segment] = "Partner"),[PRJ])
return
if(not(isblank(_cnt)) && not(isblank(_cnt1)) , "Owner", "Other")
