Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cluster Column Chart Not calculating percent of string variable by x-axis correctly

Hello,    I searched this forum, but I could not find anything that solved my issue. I have a matrix table with the count of two different categories by year. If I add my value and show as "pecent ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I figured it out. 

     

    The measure I needed was: 

     

    Measure = DIVIDE(

    COUNT(DISP_HISTORY[CD Count]),
    CALCULATE(COUNT(DISP_HISTORY[CD Count]), AllSelected (DISP_HISTORY[CD Count)))
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Try one of the following meassures:

 

Measure = 
DIVIDE(
    COUNT(DISP_HISTORY[CD Count]),
    CALCULATE(
        COUNT(DISP_HISTORY[CD Count]), 
        ALLSELECTED(DISP_HISTORY[Start of Week])
    )
)
Measure = 
DIVIDE(
    COUNT(DISP_HISTORY[CD Count]),
    CALCULATE(
        COUNT(DISP_HISTORY[CD Count]), 
        ALLSELECTED(DISP_HISTORY[Year])
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply šŸ™‚

YouTube  LinkedIn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you. The first measure gives me 100% for all columns. 

     

    The second measure gives me the percentage by legand (CD Count) rather than Axis (year) 

     

    ā€ƒ