ALLEXCEPT for multiple columns/Filters

[cristianml]

Hi,

I need help with the following DAX formula:

VAR V1 = CALCULATE([Revenue],ALLEXCEPT(Revenue,Revenue[Contract]))

RETURN

DIVIDE([Revenue],V1)

What I Need is to use different filters to calculate the % of total only for the information filtered so I can apply to other measures.

The problem is when I use filters that is not "Contract" is calculating based on all that is not filtered. 

Meaning/Example: In this case When I filter by FY22 it gives 23,09 %  but I need 100% like above.

Hope you can help me .

Thanks !

[Mahesh0016 · Accepted solution]

Hello @cristianml ,

% listPrice =

VAR V1 = CALCULATE([Total listPrice],ALLSELECTED(TrainingSample2[Business Segment]))

RETURN

DIVIDE([Total listPrice],V1,0)

Please try this one.

[Vilmar]

Tente:

_01 % Revenue =
DIVIDE (
    [Revenue],
    CALCULATE ( [Revenue], REMOVEFILTERS ( [Revenue[Contract] ) )
)

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[DataInsights]

@cristianml,

In your measure [_01 % Revenue], have you tried using V3 in line 6 instead of V1?

DIVIDE ( [Revenue], V3 )

This will cause the denominator (V3) to use the filter context that exists outside the visual (i.e. slicers and filters). If this doesn't solve the issue, please provide a link to a sample pbix using one of the file services like OneDrive.