Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Community:
Situation is I've got a drill thru from one page to another. The "expected" behavior is that the drill thru page should return a filtered list of orders on a table on that page. If I have a certain measure on that table (the first one listed below), the drill thru page returns ALL records...not the ones that should have been filtered from the originating page. If I remove that measure from the table I get the filtered list. So I need to fix that measure (or one of the measures in that measure). Below are the measures involved.
Again, my end goal is that the table on the drill thru page just shows the filtered results, not all records.
Solved! Go to Solution.
Such an odd behavior! I'd just double check to make sure your tables are related properly.
Hi @Anonymous
Try if this measure works
Order Performance Measure (Early + On Time %) =
IF (
ISBLANK ( [Number of Orders] ),
BLANK (),
DIVIDE ( [EarlyOrderCount] + [OnTimeOrderCount], [Number of Orders] ) + 0
)
Or
Order Performance Measure (Early + On Time %) =
IF (
NOT ( ISBLANK ( [Number of Orders] ) ),
1 - DIVIDE ( [LateOrderCount], [Number of Orders] )
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |