Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
3 years ago
Solved

ALLEXCEPT for multiple columns/Filters

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 ...
Data Protection
General Comment
Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    Hello cristianml ,
    % listPrice =
    VAR V1 = CALCULATE([Total listPrice],ALLSELECTED(TrainingSample2[Business Segment]))

    RETURN

    DIVIDE([Total listPrice],V1,0)

     

    Please try this one.
Vilmar's avatar
Vilmar
Resolver I
3 years ago

Tente:

 

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