Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 period.
For this, I have a table with a document for each row. Each document has a creation date and a processing date.
To study the documents to be processed over a given period, I've created a Calendar = CALENDARAUTO() table, which I use in a slicer.
Then, for a selected period, I filter my data table with the number of documents to be processed before this period and those to be processed at the end of this period.
Problem :
In the problem I encounter, I study the number of documents processed over the period with this measure :
I analyze this number with graphs on various dimensions.
In my example, I look at the locations of the documents to be processed.
Then I create a measure to determine whether the document to be processed is delayed or on-time.
The measure is as follows:
The results of these measures are both good
However, the dynamism of my graphs is not.
When I click in my graph of processed documents with a legend by location, my graph studying on-time and delayed cases is also filtered.
However, when I click on an element in my graph concerning document processing times, my first location graph is not filtered.
However, when I click on one of the elements of a visualization table, the 2 graphs are filtered.
I think I need to adapt my measures but I don't know how. I understood that I should probably use the treatas function but I've never used it. Can you help me?
Thanks in advance !
@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-tr...
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])))
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!