Disable date slicer value for measure used in table visual

[raj777karthik]

In a table chart, we used certain columns and measures.But in one of the measure the values should be static irrepestive of date range silcer .The measure should be always static even though if i drag date range slicer to any certain date range.

CALCULATE(DISTINCTCOUNT(sales[salesid]),Sales,Sales[Priority P0]=1||Sales[Priority P1]=1 ||Sales[Priority P2]=1),allexcept(order,orderid))

var b=DISTINCTCOUNT(Sales[Salesid]),

return

calculate(coalesce(DIVIDE(a,b),0)

Sales and order tables are connected with both direction .Date Slicer we used from anothe table header table and is connected with order table and both direction.

[v-jinweili-msft]

Hi @raj777karthik ,

Sorry for that the information you have provided is not making the problem clear to me.

1. I have known that there are three tables, but what fields are contained in these tables?
2. What fields do these tables rely on to create relationships?

Can you please share more detail information to help us clarify your scenario? Or share me with your pbix file after removing sensitive data.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

For more information about removing Filters in Power BI, you could kindly refer to:

ALL function (DAX) - DAX | Microsoft Docs

REMOVEFILTERS function (DAX) - DAX | Microsoft Docs

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

[amitchandak]

@raj777karthik , Try like

Blocked =
var a=CALCULATE(DISTINCTCOUNT(Sales[Salesid]),ALLEXCEPT(Sales,order[OrderId]),filter(Sales,Sales[PriorityP0]=1||Sales[PriorityP1]=1 ||Sales[PriorityP2]=1))
var b=DISTINCTCOUNT(Sales[Salesid])
return
calculate(coalesce(DIVIDE(a,b),0)

or use removefilters for date