Forum Discussion
Filtered Measure help
Create the Measure for the Count of People with Position Code 5 and Training Status R or Q:
Use a DAX measure to filter the table and count only those people with Position Code = 5 and Training Status = "R" or Training Status = "Q".
Qualified_Count = CALCULATE( COUNTROWS(YourTableName), YourTableName[Position Code] = 5, YourTableName[Training Status] IN {"R", "Q"} )Create a Measure for the Total Number of People with Position Code 5:
This measure will count the total number of people with Position Code = 5.
Total_PositionCode5_Count = CALCULATE( COUNTROWS(YourTableName), YourTableName[Position Code] = 5 )Create a Measure for the Qualification Percentage:
Now, divide the count of qualified people by the total number of people with Position Code = 5 to get the percentage.
Qualification_Percentage = DIVIDE( [Qualified_Count], [Total_PositionCode5_Count], 0 )
Create the Measure for the Count of People with Position Code 5 and Training Status R or Q:
Use a DAX measure to filter the table and count only those people with Position Code = 5 and Training Status = "R" or Training Status = "Q".
Qualified_Count = CALCULATE( COUNTROWS(YourTableName), YourTableName[Position Code] = 5, YourTableName[Training Status] IN {"R", "Q"} )Create a Measure for the Total Number of People with Position Code 5:
This measure will count the total number of people with Position Code = 5.
Total_PositionCode5_Count = CALCULATE( COUNTROWS(YourTableName), YourTableName[Position Code] = 5 )Create a Measure for the Qualification Percentage:
Now, divide the count of qualified people by the total number of people with Position Code = 5 to get the percentage.
Qualification_Percentage = DIVIDE( [Qualified_Count], [Total_PositionCode5_Count], 0 )
Thank you - worked perfectly and taught me something new!
