Custom Value filtering table

[romovaro]

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 

[Ashish_Mathur]

Hi,

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

[v-eqin-msft · Accepted solution]

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]

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