Math works... Banding doesn't

[Anonymous]

Hi all,

I have a slightly more complex measure and I don't know what is happening. I am calculating the Index score correctly however when I try to use the banding method of categorizing the categories get wierd. 

 Code:

Activity Index by Account = 

VAR purchases365 =
CALCULATE (
DATEDIFF ( SELECTEDVALUE('A/C Relationship'[Aircraft Date Purchased]), TODAY (), DAY),
FILTER (
Aircraft,
Aircraft[Aircraft Manufacture Code] = "ABC"
|| Aircraft[Aircraft Manufacture Code] = "123"
),
USERELATIONSHIP ( 'A/C Relationship'[Aircraft ID],Aircraft[Aircraft ID] ),FILTER(Aircraft,Aircraft[Aircraft Classification]="JET"||Aircraft[Aircraft Classification]="TURBO")
) 

//Calculating the index based on a calulated column (Task[Activity Index])
var actInd = IF(purchases365<=365,
    CALCULATE(ROUND(SUMX(CALCULATETABLE(Task,
            GROUPBY(Task,Task[AccountId],Task[Engaged__c],Task[DB_Activity_Type__c],Task[CreatedDate],Task[OwnerId])),
        Task[ActivityIndex])+(4*EXP(-0.0027*DATEDIFF(LASTDATE('A/C Relationship'[Aircraft Date Purchased]),TODAY(),DAY))),2)),
            CALCULATE(ROUND(SUMX(
        CALCULATETABLE(Task,GROUPBY(Task,Task[AccountId],Task[Engaged__c],Task[DB_Activity_Type__c],Task[CreatedDate],Task[OwnerId])),
        Task[ActivityIndex]),2)))

return
//Banding Categorization
CALCULATE (
VALUES ( 'Activity Index Grouping'[Index]),
FILTER (
'Activity Index Grouping',
actInd >= 'Activity Index Grouping'[Min]
&& actInd< 'Activity Index Grouping'[Max]
)
)

[Greg_Deckler · Accepted solution]

Any way that you can provide sample data and expected output of that sample data? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Tough to say, but seems like some kind of dynamics categorization so perhaps this Quick Measure might assist:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146