Or statement with Slicer for the user

[majo23]

Hi everyone,

I have a request to develope a table that interact with multiple Slicers, I have a summarize table like this: 

Table = SUMMARIZE ( FILTER(tJobs, tJobs[WorkCompleted] = 0 && tJobs[WorkFlag] = 1)

, tContractProgram[ProgramName]

, tPackage[Package]

, tJobs[JobNumber]

, tJobs[WorkCompletedFlag]

, tJobs[WorkFlag]

, "ACS", CALCULATE ( COUNTROWS (tJobs), SEARCH ("ACS", tJobs[Task],,0 ))

, "ARTC", CALCULATE ( COUNTROWS (tJobs), SEARCH ("ARTC", tJobs[Task],,0 ))

) but I need this table to be able to interact with OR CONDITION with 5 slicers, (by default slicers works as AND CONDITION), I could maybe used the solution of Padycosmos here https://community.fabric.microsoft.com/t5/Desktop/Slicers-and-OR-statement/m-p/3115827#M1055537, but if I get more slicers next time I dont think its a good idea to made a different table for each filter (slicer)

I have this amount of slicers that I need to interact with the table

Any comment its really appreciate

Have a nice day! 🙂

[amitchandak]

@majo23 , A calculated table and Calculated column can not use slicer value. Create a measure and visual level table and use measure a visual level filter for the table

[majo23]

Hi @amitchandak thanks for the reply, is it possible for you to made an example maybe with a dummy measure, with 5 slicers or so?