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" && 'Celer...
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.

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