Need help to calculate measuring values without apply slicer filter value

[sridevi]

Hi,

Is it possible to apply without filtering in my own formula measure column.

I am used below formula for my measure column hit rate.

Hit rate= No. of units of prod release / total no. of units

Here all above variables are my own measures values.  I dont want to apply slicer fiter value for total.no of units value while I am selecting product release value filter slicer. How can I restrict my filter in total no.of units measurement.

Example: No. of units of prod release value should be calcuated based on my slicer selection value and total no. of units value calculated count all the units from table without applying slicer selection.

Could you please help me to resolve this issue if anyone knows?

Thanks in advance.

Regards

Sridevi

[ankitpatira · Accepted solution]

@sridevi ALL() function within DAX is your help then. Here's the article on it. Basically it lets you ignore any filter applied. So you can say

Hit rate= No. of units of prod release / ALL(tableName[total no. of units ColumnName])

[sridevi]

@ankitpatira Thanks a lot. Its working fine for me.