Forum Discussion
Cumulative total should display till the value exist
Hello All,
I have two following measures,
1. Planned = Cumulative total of all planned (Admin, training) hours accorss different tasks ( 3 to 10)
2. Actual = Cumulative total of actual hours Admin hours completed accross different tasks ( Note : Only till Task 6 there are completed Admin hours and there are no admin hours clocked against the remaining tasks 7,8,9,10 )
But the visual would continue to show data till the last task, which is not necessary . Instead Actual completed hours should show values till task 6 only.
How do we achive this ?
DBA_BI , assume you have a measure Actual, try a measure like
if(isblank([Actual]), blank(), calculate([Actual), filter(allselected(Task), Task[ID] <= Max(Task[Id]) ) )
2 Replies
- amitchandak
Super User
DBA_BI , assume you have a measure Actual, try a measure like
if(isblank([Actual]), blank(), calculate([Actual), filter(allselected(Task), Task[ID] <= Max(Task[Id]) ) )
Thank you so much amitchandak. You are always been a great support to the whole Power BI community.
