Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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] ) )
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |