Forum Discussion

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

Measures that do not filter each other graphically

Hello ! ðŸ™‚   I have a problem with 2 measures in Power BI.   Context :  My dashboard should respond to the following case: I want to study the flow of documents to be processed over a given per...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

LeroyPaul , For More than one dat analysis prefer active inactive join approach

 

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

 

 

Once you have measure ready with use relation, then use it in cumulative measure if needed

 

Cumm Sales = CALCULATE([Measure],filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE([Measure],filter(allselected(date),date[date] <=max(date[Date])))