Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
LeroyPaul
Helper I
Helper I

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 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 :

CloseDoc = CALCULATE(COUNT(Feuil1[Tag Doc]),FILTER(Feuil1,Feuil1[CreationDate]<=[Max Calendar]&&Feuil1[LasModification Date]>=[Min Calendar]))
 
Min Calendar & Max Calendar represent the limits of my period

 

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: 

Close Delayed = CALCULATE(COUNT(Feuil1[Tag Doc]),FILTER(Feuil1,[LasModification Date]>'Feuil1'[Danger Date Zone]),FILTER(Feuil1,Feuil1[CreationDate]<=[Max Calendar]&&Feuil1[LasModification Date]>=[Min Calendar]))

 

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.

LeroyPaul_0-1698011583747.png


However, when I click on an element in my graph concerning document processing times, my first location graph is not filtered.

LeroyPaul_1-1698011638559.png

 

However, when I click on one of the elements of a visualization table, the 2 graphs are filtered.

 

LeroyPaul_2-1698011762332.png

 

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 !

 

1 REPLY 1
amitchandak
Super User
Super User

@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])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors