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.
Mahesh0016's avatar
Mahesh0016
Super User
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.