Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
4 years ago
Solved

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/Par...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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")

amitchandak's avatar
amitchandak
Super User
4 years ago

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")

harshagraj's avatar
harshagraj
Post Partisan
4 years ago

Hi amitchandak the above calculations work perfectly but i have an slicer Region Code.
When i modify like this 
var _cnt = countx(filter(Table, [PRJ] =earlier([PRJ]) && [Segment] =71&&[Regioncode]=selectedvalue(regoincode)),[PRJ]) it doesnt work but when i modify like this it works var _cnt = countx(filter(Table, [PRJ] =earlier([PRJ]) && [Segment] =71&&[Regioncode]="0401",[PRJ])
could you please help me on this?

  • harshagraj's avatar
    harshagraj
    Post Partisan
    4 years ago

    Hi amitchandak please help me to adjust the calculation so that if we select region code as 0401 then the calcuation should happen accordingly. Currently if i select 0401 it doesnt work.I dont want to hardcode