Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Fixed Value at Dimension Level

Hi,   Here, I am struggling to calculate custom column based on another two dimensions. In below example, I wanted to calculate the field called "Main Task Status", which has to pick up the value ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Is this what you want. Add as custom column

     

    Main Status = 
VAR
ITComp = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="Completed"))

VAR
ITProg = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="Progress"))

VAR
ITToDo = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="To Do"))

VAR
ITAll = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT"))

Return
IF(ITComp = ITAll,"Completed",IF(ITProg = ITAll,"Progress",IF(ITToDo = ITAll,"To Do","Progress")))

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is this what you want. Add as custom column

 

Main Status = 
VAR
ITComp = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="Completed"))

VAR
ITProg = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="Progress"))

VAR
ITToDo = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT" && Table1[Status]="To Do"))

VAR
ITAll = 
COUNTROWS(FILTER(Table1,Table1[Main Task]=EARLIER(Table1[Main Task]) && Table1[Category]="IT"))

Return
IF(ITComp = ITAll,"Completed",IF(ITProg = ITAll,"Progress",IF(ITToDo = ITAll,"To Do","Progress")))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi chirayuw,

     

    Perfectly working...Thanks Heaps...!

     

    Best Regards,

    Ganesh