Forum Discussion

abanar2's avatar
abanar2
Icon for Helper I rankHelper I
2 years ago

Need help with my measure

Hello Community,    I’m currently working on a project where I need to calculate Key Performance Indicators (KPIs) using a DAX measure, but I’m having some difficulties and could use your help. I ...
Need Help
abanar2's avatar
abanar2
Icon for Helper I rankHelper I
2 years ago

This is the sample dataset.

YearQuarterSite_IDKPI_IDKPI_NameIs_Total_KPIKPI_GroupKPI_ValueDividend_IDDivisor_ID
20211Site1KPI1Training PlannedYes% Training Done during the Quarter79KPI2KPI1
20212Site1KPI1Training PlannedYes% Training Done during the Quarter75KPI2KPI1
20213Site1KPI1Training PlannedYes% Training Done during the Quarter67KPI2KPI1
20214Site1KPI1Training PlannedYes% Training Done during the Quarter77KPI2KPI1
20221Site1KPI1Training PlannedYes% Training Done during the Quarter33KPI2KPI1
20222Site1KPI1Training PlannedYes% Training Done during the Quarter71KPI2KPI1
20223Site1KPI1Training PlannedYes% Training Done during the Quarter11KPI2KPI1
20224Site1KPI1Training PlannedYes% Training Done during the Quarter49KPI2KPI1
20211Site2KPI1Training PlannedYes% Training Done during the Quarter34KPI2KPI1
20212Site2KPI1Training PlannedYes% Training Done during the Quarter25KPI2KPI1
20213Site2KPI1Training PlannedYes% Training Done during the Quarter73KPI2KPI1
20214Site2KPI1Training PlannedYes% Training Done during the Quarter10KPI2KPI1
20221Site2KPI1Training PlannedYes% Training Done during the Quarter67KPI2KPI1
20222Site2KPI1Training PlannedYes% Training Done during the Quarter96KPI2KPI1
20223Site2KPI1Training PlannedYes% Training Done during the Quarter29KPI2KPI1
20224Site2KPI1Training PlannedYes% Training Done during the Quarter83KPI2KPI1
20211Site1KPI2Training DoneNo% Training Done during the Quarter13KPI2KPI1
20212Site1KPI2Training DoneNo% Training Done during the Quarter16KPI2KPI1
20213Site1KPI2Training DoneNo% Training Done during the Quarter18KPI2KPI1
20214Site1KPI2Training DoneNo% Training Done during the Quarter28KPI2KPI1
20221Site1KPI2Training DoneNo% Training Done during the Quarter36KPI2KPI1
20222Site1KPI2Training DoneNo% Training Done during the Quarter88KPI2KPI1
20223Site1KPI2Training DoneNo% Training Done during the Quarter35KPI2KPI1
20224Site1KPI2Training DoneNo% Training Done during the Quarter88KPI2KPI1
20211Site2KPI2Training DoneNo% Training Done during the Quarter80KPI2KPI1
20212Site2KPI2Training DoneNo% Training Done during the Quarter34KPI2KPI1
20213Site2KPI2Training DoneNo% Training Done during the Quarter75KPI2KPI1
20214Site2KPI2Training DoneNo% Training Done during the Quarter18KPI2KPI1
20221Site2KPI2Training DoneNo% Training Done during the Quarter49KPI2KPI1
20222Site2KPI2Training DoneNo% Training Done during the Quarter33KPI2KPI1
20223Site2KPI2Training DoneNo% Training Done during the Quarter96KPI2KPI1
20224Site2KPI2Training DoneNo% Training Done during the Quarter27KPI2KPI1
20211Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office10000
20212Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office10000
20213Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office10000
20214Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office10000
20221Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office9000
20222Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office9000
20223Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office9000
20224Site1KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office11000
20211Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20212Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20213Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20214Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20221Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20222Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20223Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7000
20224Site2KPI3Number of Focus Rooms in the OfficeYesNumber of Focus Rooms in the Office7200