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

Join 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.

Reply
Anonymous
Not applicable

Measure count of graph differs from Measure display on Drillthrough Page

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


6 REPLIES 6
JimmyKhan2022
Frequent Visitor

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 .

JimmyKhan2022
Frequent Visitor

@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 ?

JimmyKhan2022_0-1680910926128.png


JimmyKhan2022_1-1680911042761.png

 

 

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.

Anonymous
Not applicable

@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 . 

JimmyPappa2020_0-1680559755623.png

 

I don't see that.

With the extra filter:

lbendlin_0-1680570298334.png

 

Without the extra filter:

lbendlin_1-1680570382287.png

These customer IDs result in a blank measure return value

lbendlin_2-1680570874949.png

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() ).

lbendlin
Super User
Super User

Always check the applied filters.

lbendlin_0-1680481019268.pnglbendlin_1-1680481042093.png

The table has one more filter.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.