Forum Discussion

AlanP514's avatar
AlanP514
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...
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 )
rohit_singh's avatar
rohit_singh
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! 🙂

AlanP514's avatar
AlanP514
Post Patron
4 years ago

Hai rohit_singh,I have a model number but that is a fully text data type so I cannot sum

This is the measure and this column consist of text values so i am taking distinct count 
can you change your measure based on this 

  • rohit_singh's avatar
    rohit_singh
    Solution Sage
    4 years ago

    Hi AlanP514 ,

    Please try this :

    % Share Range =

    var _total =
           SUMX(
                ALLEXCEPT(Markets, Markets[Market]),
                [# Model Number]
    )

    var _target =
            DIVIDE(SUMX(Markets,[# Model Number]), _total, 0)

     

    Return
    _target

     

    Here [# Model Number] is your measure.

    Kind regards,

    Rohit


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

     



    • AlanP514's avatar
      AlanP514
      Post Patron
      4 years ago

      Hai rohit_singh 

      This is what i am getting based on the above measure what's the error

      • rohit_singh's avatar
        rohit_singh
        Solution Sage
        4 years ago

        You forgot to return the value AlanP514