Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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])))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
100 | |
72 | |
44 | |
38 | |
29 |
User | Count |
---|---|
156 | |
92 | |
62 | |
44 | |
41 |