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 there,
I got data that contains app_id, stage of the application process. An app_id can have multiple stages. To pick the latest stage, there is a column called attribute order which contains a number from 1 to 5. I want to show the latest stages of the application that are 'in progress'. I created a following measure to calculate the no of in progress applications as follow:
I am not sure how to present the map the attribute values to the above mentioned measure. Any help would be really appreciated.
Sample file here
@Dunner2020 , try a measure like
Measure =
VAR __id = MAX ('Table'[App_ID] )
VAR __date = CALCULATE ( MAX('Table'[Attribute Order] ), ALLSELECTED ('Table' ), 'Table'[App_ID] = __id,'Table'[Application_Status__c] = "In Progress" )
CALCULATE ( Countrows ('Table' ), VALUES ('Table'[App_ID] ),'Table'[App_ID] = __id,'Table'[Attribute Order] = __date,'Table'[Application_Status__c] = "In Progress" )
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 |