Removing effect of slicer and putting my own filters on table

[Anonymous]

Hello everyone!!

I want to create a mesure which would show me the count where rc month is less than of equal to chosen slicer month and rcm month is less than of equal to chosen slicer month by selecting only one month from slicer. Say i chose april only from slicer the count of rows from jan till april should be shown. I have a date dimension from where i am filtering my month and its effect is shown in fact table but only till the chosen month.  Here is the dax i am using

CALCULATE(COUNTROWS('fact table'),FILTER(ALL('fact table'),

'fact table'[rc month] >=1 && 'fact table'[rc month]<= MAX('Date dimension'[Date Key]) ,filter(all('fact table')

'fact table'[RCM month]>=1 && 'fact table'[RCM month] <= MAX('Date dimension'[Date Key]) &&

NOT('fact table'[RCM month]) = BLANK() )))

this dax is shwoing me correct aggregated value but i want to show the result for each row independently by removing the effect of slicer and putting my own filter to get data correctly for each row.

[MFelix · Accepted solution]

Hi @Anonymous ,

First of all believe that your measure is over complicated since you are using two times the ALL syntax over the FACT table believe that you can adjust you measure to be:

CALCULATE (
    COUNTROWS ( 'fact table' ),
    FILTER (
        ALL ( 'fact table' ),
        'fact table'[rc month] >= 1
            && 'fact table'[rc month] <= MAX ( 'Date dimension'[Date Key] )
            && NOT ( 'fact table'[RCM month] ) = BLANK ()
    )
)

When you are refering to have your filter independent from your slicer what do you mean? How do you want to gilter the information?

Can you share a sample file and expected result?