Forum Discussion

KRISH80's avatar
KRISH80
Icon for Helper II rankHelper II
6 years ago
Solved

Need Help with DAX Formula

I need to Calculate Ratio of our WINS where the manufacturer is not equal CISCO and certain other filtering to be applied. The formula is not giving me any error but it is not showing me the result. ...
DAX filter formula
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    GS Ratio =
DIVIDE (
    CALCULATE (
        SUMX (
            'Closed Opprtunities',
            'Closed Opprtunities'[TS] + 'Closed Opprtunities'[SS] + 'Closed Opprtunities'[MS] + 'Closed Opprtunities'[TRNG] + 'Closed Opprtunities'[CS]
        ),
        FILTER (
            'Closed Opprtunities',
            'Closed Opprtunities'[OEM] <> "CISCO"
                && 'Closed Opprtunities'[Attach] <= 0
                && 'Closed Opprtunities'[SNT] <= 0
                && 'Closed Opprtunities'[VBR] <= 0
        )
    ),
    [TOTAL-WINS],
    0
)
HarsimranPWRBI's avatar
HarsimranPWRBI
Icon for Helper I rankHelper I
6 years ago

Question : IS [TOTAL-WINS] is a measure? if no then use some aggregation on same

Also if this does not answer your question please provide sample data for Power bi model for same and include some screenshots too.

 

Thanks,

Harry