Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Inconsistent display of data in Power BI Desktop vs Excel

I am seeing data inconsistencies between what's displayed in Power BI Desktop and Excel.  I suspect it has something to do with the TicketCount dax that I am using to ensure Merchant Locations with no tickets are returned.  See all info below.  It seems every location is repeated for every merchant.  Btw Model is hosted in SSAS Tabular 2014

data issues power bi.png

Need Help
  • leonardmurphy's avatar
    leonardmurphy
    10 years ago

    I tried recreating based on what I know about your tables/fields but I didn't see a difference between Excel & Power BI Desktop (2.28.4190.122).

     

    Now, I'm not anybody special, and if your model is complex, me attempting a recreation probably doesn't mean much.

     

    If you can share more about your tables/fields/relationships I can see if I'm still having the same issue when I mimic your model more closely. If you don't care to do that and know it's a genuine bug, I'd say send a frown directly from within the application.

     

    Sorry I've not been overly helpful.

     

    Edit: Could also be a difference because I recreated the setup in Excel rather than SSAS

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      If you replace the 0 value with Blank() you lose merchants that do not have Ticket Count.  It's important to see all merchants especially those with no Tickets.

       

      • leonardmurphy's avatar
        leonardmurphy
        Icon for Skilled Sharer rankSkilled Sharer
        10 years ago

        Ah, sorry, I misunderstood. And MerchantName and LocationName are both fields in the same table?