Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago
Solved

Custom Value filtering table

HI PowBI,

 

I created a custom measure using the 2 formulas below:

 

all task = 0+CALCULATE (
COUNT('Celergo-PreEngTeam'[CID] ),
'Celergo-PreEngTeam'[TASK] = "Pre Engagement Process" && 'Celergo-PreEngTeam'[TASK_STATUS] IN {"Closed", "Received"}
|| 'Celergo-PreEngTeam'[TASK] = "IPM Hand Off" && 'Celergo-PreEngTeam'[TASK_STATUS] = "Received"
)

 

IPM_HandOff-closed =
CALCULATE (
[Total Rows],
'Celergo-PreEngTeam'[TASK] = "IPM HandOff",
'Celergo-PreEngTeam'[TASK_STATUS] = "closed"
)
 
To get the current workload. (Tasks that hte Pre Engagement team are currently working on:)
Current Workload =
[all task]-[IPM_HandOff-closed]
 
Total is 27.
 
 Now I would like to show in a table ONLY the 27 but I am having issues. I get more than wanted. Tried to add different filters but...Any idea?
 

 

 

 

Samarth_18 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi romovaro ,

     

    According to your descriptin, it seems that you want to show 27 rows based on some filters.

     

    I have built a data sample, please tell me your expected output:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi romovaro ,

     

    According to your descriptin, it seems that you want to show 27 rows based on some filters.

     

    I have built a data sample, please tell me your expected output:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • romovaro's avatar
      romovaro
      Responsive Resident
      4 years ago

      HI Evelyn

       

      thanks. It works. I can show the resuls i need (due to current data...now is 24).

      I have been asked to show a "time table" month or week with current workload by owner. THe problem i have with this one is that sometimes it shows negative results....and that's not possible. Or you have current workload during the months or zero...but not negative...any fix? thanks

       

       

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    Drag the current workload measure (which returns number 27) to the visual as well.