Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have the following measure below that is displayed on a trend graph . It displays 213 on the graph for Feb but on the drillthrough page it displays 215 . The user click on 213 for Feb and then goes to the Drillthrough page that only displays the measure in a card and it says 218 .
I have checked all the filters on both pages and checked and double checked the measure and cannot understand this. Any ideas ?
Lost Cust by Month Graph LOST CUSTOMERS =
var _table =
CALCULATE ( DISTINCTCOUNT('Customer'[customer_id]),
FILTER(SUMMARIZE('Customer', 'Customer'[customer_id]
),
( [Previous 24 Months Revenue]=0||[Previous 24 Months Revenue]=Blank()) && [Minus 25th Month Revenue]>0.000001
)
)
return _table
Replication of Error in SAMPLE File attached ( Tabs lost Customers and the Drillthrough Page )
In this example Feb has 213 for the lost cusotmer count on the Graph which then becomes 215 on the Drillthrough .
PowerBI_TEST
This does not explain the difference between the graph and the drillthrough page . That is not to do with the filters. I have checked the applied filters on both pages and they are the same .
@lbendlin - To clarify, I have put the new measure in play. Thank you for simplifying that . So are you not able to replicate and see the graph displaying for Feb , 220 but on the drillthrough page with the same filters its says 219 for Feb 2023 ? This difference is really confusing me as I cannot see what the missing one is ? Is this something to do with the Power BI version if with the same pbix you cannot see this issue ?
Your problem is that the measure returns BLANK() for a couple of Customer IDs. That is always a source for discrepancies like the one you experience.
@lbendlin This does not cover the problem . I have two visuals on the drillthrough .One with the additional filter and one without . The additional filter was to see if I could get the magical 217 figure for FEB 2023. If I take the additional filter off which is the measure on the graph I still get the problem ? I should get 217 on this page and NOT 216 .
I don't see that.
With the extra filter:
Without the extra filter:
These customer IDs result in a blank measure return value
Anyway, I would simplify your measure like this
Lost Cust by Month Graph LOST CUSTOMERS =
var a = SUMMARIZE('Customer', 'Customer'[customer_id],"flag",if(COALESCE([Previous 24 Months Revenue],0)=0 && [Minus 25th Month Revenue]>0.000001,1,0))
return sumx(a,[flag])
and then hunt for the remaining gremlins (measures returning BLANK() ).
Always check the applied filters.
The table has one more filter.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
8 |