Forum Discussion

Icon for Post Patron rank

Post 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...

Tips and Tricks

4 years ago

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 )

Icon for Solution Sage rank

Solution Sage

4 years ago

Hello AlanP514 ,

Please try creating this measure. It gives the expected output.

% Share Range =

var _total =

CALCULATE(

sum(Markets[# Model Number(Count)]),

ALLEXCEPT(Markets, Markets[Market])

)

var _target =

DIVIDE(SUM(Markets[# Model Number(Count)]), _total, 0)

Return

_target

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

Icon for Post Patron rank

Post Patron

4 years ago

Hai rohit_singh

this is the way value should be calculated