Using two filter shows error

[Anonymous]

Hi,

I have this formula shows me this error.

[amitchandak]

@Anonymous , In All, keep either table name or column name. not both.

[Anonymous]

@amitchandak Thanks but now my second condition is not working. All I want that if I use Plallned count date slicer then my count should not be affected by the end range of the slicer.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Use ALL(tablename) in your formula.

Sample data as below.

Measure = 
CALCULATE (
    COUNT ( 'Table'[date when ***] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[planed count date] >= MIN ( 'Table'[planed count date] )
            && 'Table'[date when ***] >= MIN ( 'Table'[planed count date] )
    )
)

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous]

Thanks @Anonymous, I really appreciate your help and explaining with example. I am stuck on this for days, 😞  the formula works but now giving me the desired value, what I want is a count against any dimension I put, it should not affect my planned date slicer end date. below is the excel example.

Its simple count of date lines, just with two date range condition

1. Planned date should not affect what's been selected in end date as I have shown below.

2. Date adjusted should always take count same as Planned date- start date but end date should be max of date adjusted.

[amitchandak]

@Anonymous , If you all table[date] in filter then you will only get that date in filter

Add all(Table[date]) separately, Use only table name in filter