Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Segmenting Accuracy and Not all Values being categorized

Hi,

I am trying to categorize results into 4 categories and then show them on a bar chart.

 

 

Classify % Completion Accuracy =
CALCULATE (
    [% Completion Accuracy],
    FILTER (
        VALUES ( vwJIRASprintSnapshots_V2_UAT[Feature Epic] ),
        COUNTROWS (
            FILTER (
                Classification,
                RANKX ( ALL ( vwJIRASprintSnapshots_V2_UAT[Feature Epic] ), [% Completion Accuracy],, DESC ) >= Classification[Min]
                    && RANKX ( ALL ( vwJIRASprintSnapshots_V2_UAT[Feature Epic] ), [% Completion Accuracy],, DESC ) <= Classification[Max]
            )
        ) > 0
    )
)
 
My problem is that it is ignoring certain values (I have 100's) and it is reflecting things as Min when they should be High and so on and so forth.   I have everything stored as decimals and the two tables are disconnected. Can someone please advise?

 

 
 
 
Need Help

3 Replies