calculate sum in a measure ignoring the slicer date filter

[jesly_ajin]

Dears,

I have a column with rownumber for each group. I need to calculate sum in a measure ignoring the slicer date filter, but need the

sum of all rows with rownumber as 1 for a particular project.

Currently, my sum is getting filtered with the date filter as my page has a slicer for date filter:-

CALCULATE(SUM(SelfService_Plan_DailyPlanQuantity[AllowableHoursEQ]),Filter(ALL(SelfService_Plan_DailyPlanQuantity),SelfService_Plan_DailyPlanQuantity[RowCount]=1))

Kindly help.

.

[tkirilov]

Perhaps this would help:

https://community.powerbi.com/t5/Desktop/Ignore-Slicer-in-measure/td-p/49734

[Anonymous · Accepted solution]

Try this

Calculate(sum(table[hour]),allexcept(table,table[Project]),filter(table,table[rownum]=1)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.