topic Re: Create a measure ignoring existing page slicers in DAX Commands and Tips

Create a measure ignoring existing page slicers

snehasissamal — Wed, 04 Dec 2024 15:16:41 GMT

Hi,

I have projects with Name, Year, Planned Quarter, Actual Quarter as different quarters. Also I have two slicers Year and PlannedQuarter. I am able to show the number of planned projects in the selected quarter(s) and it's working fine.

But few projects planned in Q1 for example, executed in Q2 and so on. So I need to calculate the count how many acctualy executed in Q1. For that I need to remove the existing filter with REMOVEFILTER or can use ALL. So that I can ignore page slicer and apply other filters I want. But struglling with that part, any hints/help is much appreciated,

Attaching the .pbix file with data too for reference. Sample PBIX File

TotalProjects = COUNTROWS(Sheet1) + 0

TotalActualCasesCount = VAR selectedQuarters = ALLSELECTED(Sheet1[PlannedQuarter]) VAR All_Projects = ALL('Sheet1') //VAR All_Projects_RemoveFilter = REMOVEFILTERS('Sheet1', 'Sheet1'[PlannedQuarter]) RETURN CALCULATE([TotalProjects], Sheet1[ActualQuarter ] in selectedQuarters) + 0

Re: Create a measure ignoring existing page slicers

Jihwan_Kim — Wed, 04 Dec 2024 17:47:42 GMT

Hi,

I am not sure if I understood your question correctly, but please try something like below and please check if it produces the result that you want.

TotalActualCasesCount = VAR selectedQuarters = VALUES ( Sheet1[PlannedQuarter] ) RETURN COUNTROWS ( FILTER ( ALL ( 'Sheet1' ), Sheet1[ActualQuarter ] IN selectedQuarters ) )

Re: Create a measure ignoring existing page slicers

Anonymous — Mon, 09 Dec 2024 07:03:18 GMT

Hi snehasissamal

Thank you very much Jihwan_Kim for your prompt reply.

Try this:

Measure TotalActualCasesCount = CALCULATE( [TotalProjects], REMOVEFILTERS(Sheet1[PlannedQuarter]) ) + 0

Regards,

Nono Chen

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