Forum Discussion
How to show summarized data dynamically
- 2 years ago
output :
check solution below :
step 1 :
create a config table :
step 2 :
create the following measures :
phase 1 = SUMX( scatter, DATEDIFF(scatter[start date] , scatter[step1] , day) ) phase 2 = SUMX( scatter, DATEDIFF(scatter[step1] , scatter[step2] , day) ) phase 3 = SUMX( scatter, DATEDIFF(scatter[step2] , scatter[final date] , day) ) all phases = SWITCH( TRUE(), SELECTEDVALUE(config_tbl[days_for]) = "days for phase 1" ,[phase 1], SELECTEDVALUE(config_tbl[days_for]) = "days for phase 2" ,[phase 2], SELECTEDVALUE(config_tbl[days_for]) = "days for phase 3" ,[phase 3] )\
last step :
drag and drop to the visual :
output :
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠 - 2 years ago
output :
check solution below :
step 1 :
create a config table :
step 2 :
create the following measures :
phase 1 =
SUMX(
scatter,
DATEDIFF(scatter[start date] , scatter[step1] , day)
)
phase 2 =
SUMX(
scatter,
DATEDIFF(scatter[step1] , scatter[step2] , day)
)
phase 3 =
SUMX(
scatter,
DATEDIFF(scatter[step2] , scatter[final date] , day)
)
all phases =
SWITCH(
TRUE(),
SELECTEDVALUE(config_tbl[days_for]) = "days for phase 1" ,[phase 1],
SELECTEDVALUE(config_tbl[days_for]) = "days for phase 2" ,[phase 2],
SELECTEDVALUE(config_tbl[days_for]) = "days for phase 3" ,[phase 3]
)
\
last step :
drag and drop to the visual :
output :
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Daniel29195
After testing the solution provided, I noticed that the values are not showing up correctly when all the values are selected.
Expected result when all the values are slected is
Days for phase 1 = 1
Fays for phase 2 = blank
Days for phase 3 = 37
But we are only getting only Days for phase 1 = 1. I have attached the pbix file with the solution provided here.
Could you please check this and suggest