Need to populate the data based on 2 filter conditions asap

[Anonymous]

I have a requirement where I need to populate the data based on 2 filter condition

Table : taskid, kpireport (1,0) , programname 

1. If i am choosing all the programs from the slicer, it has to show only the task related with 3000 

2. If i am choosing the specific program from the slicer, then i need to show the taskids which the column kpireport showsd the value as 1

If i choose the department name as All , i need to show the column "next_step_all" is 1

: If i choose any specific department name, i need to show the column "kpireport" is 1

How to achieve this

f3000_f= SWITCH(true(),
Projecttasks[check_filter]=False(),LOOKUPVALUE(Projecttasks[pasa_taskid],Projecttasks[next_steps_all],"1",Projecttasks[pasa_gate],SELECTEDVALUE(Projecttasks[pasa_gate])),"no value")


f3000_t = SWITCH(true(),
Projecttasks[check_filter]=True(),LOOKUPVALUE(Projecttasks[pasa_taskid],Projecttasks[KPIReport],"1",Projecttasks[pasa_gate],SELECTEDVALUE(Projecttasks[pasa_gate])),"no value")

[Anonymous]

Hi @Anonymous 

Can you send me the data in the form of a table or pbix file? This will help us deal with the problem better.

The link below is teach you how to provide your sample in the Forum .

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 

Best Regards,
Community Support Team _ Ailsa Tao