Forum Discussion

AlanP514's avatar
AlanP514
Icon for Post Patron rankPost Patron
4 years ago
Solved

Aggregation logic dax

Input Output Market Executive Relevance Category # Model Number(Count) % Share Range DE Above target 18 27.69% DE Middle target 13 20.00% DE Low target 10 15.38% DE Hi...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    AlanP514 

    Ok. Please try

    % Share Range =
VAR Numerator =
    DISTINCTCOUNT ( TableName[Model Number] )
VAR Denominator =
    CALCULATE (
        DISTINCTCOUNT ( TableName[Model Number] ),
        ALL ( TableName[Relevance Category] )
    )
RETURN
    DIVIDE ( Numerator, Denominator )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

AlanP514 

Ok. Please try

% Share Range =
VAR Numerator =
    DISTINCTCOUNT ( TableName[Model Number] )
VAR Denominator =
    CALCULATE (
        DISTINCTCOUNT ( TableName[Model Number] ),
        ALL ( TableName[Relevance Category] )
    )
RETURN
    DIVIDE ( Numerator, Denominator )