Forum Discussion
Majidbhatti
Advocate IV
Advocate IVHow to design 50 KPIs model
Hi
May I know what would be the best way to design a model where in I have around 50 KPIs and for each KPI I need to segregate into today, same day last year, month to date, month to date last year, year to date, year to date last year. Plus also I would have variations against each time dimension against each KPI?
To make it more complex there are three more dimensions above those 50 KPIs and they are actual , budget and forecast.
Do i have to create 3 x 50 x 3 = 450 measures?
May I know what would be the best way to design a model where in I have around 50 KPIs and for each KPI I need to segregate into today, same day last year, month to date, month to date last year, year to date, year to date last year. Plus also I would have variations against each time dimension against each KPI?
To make it more complex there are three more dimensions above those 50 KPIs and they are actual , budget and forecast.
Do i have to create 3 x 50 x 3 = 450 measures?
2 Replies
- parry2k
Super User
Majidbhatti you have to wait until calculation groups feature is available, read more at following blogs:
https://www.sqlbi.com/blog/marco/2019/03/01/calculation-groups-in-dax-first-impressions/
https://exceleratorbi.com.au/calculation-groups-are-coming-to-dax/
MajidbhattiThanks for the update but my client cannot wait till its released :)
What can be done as of today?
