ALLEXCEPT, but not taking ALL data

[Zyg_D]

I want something similar to ALLEXCEPT. This function takes all the table without any filter and pays attention to only one of them. Basically, I want to supply this function with the table, which is already filtered (not the table at its fullest). I unsuccessfully tried using VALUES and KEEPFILTERS. 

This was my data before I introduced additional filter:

I successfully showed the Percentage in the tooltip:

This formula was used:

Percentage = 
DISTINCTCOUNT ( Table1[ID] )
    / CALCULATE ( 
        DISTINCTCOUNT ( Table1[ID] ), 
        ALLEXCEPT ( Table1, Table1[Year] ) 
    )

Then another column was added so that data now looks like this:

It was used as a filter:

Now the results are wrong:

 There will be more filters, so I don't want to reference them all. Without referencing this new column, how can I make my results appear correct?

[v-zhenbw-msft · Accepted solution]

Hi @Zyg_D ,

We can use the following measure to meet your requirement.

Percentage = 
DISTINCTCOUNT ( 'Table'[ID] )
    / CALCULATE ( 
        DISTINCTCOUNT ( 'Table'[ID] ), 
        FILTER(ALLSELECTED ( 'Table'),'Table'[year]=MAX('Table'[year])) 
)

The result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

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