Forum Discussion

CarlBlunck's avatar
CarlBlunck
Resolver I
4 years ago
Solved

Data model - memory issue

Hi team,

 

I have a relatively simple data model and in a table visual I'm trying to add a measure (Count Distinct) that uses data from another table.  Getting a memory issue.

 

In QlikSense, this wouldn't be an issue.  This post is to get some insight into why PowerBI can't handle this as I'm extremely new to the product and data modelling within it.

 

Cheers

Carl

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    CarlBlunck 

     

    Hope all is well.

     

    A few reasons for this could be to do with the current structure of your data model and the relationship structure as well as the bi-directional approach being taken.  

     

    If you can provide a bit of sample data, it will be easier for the Community to assist and provide reasoning for the cause.

     

    Thanks heaps,

    Theo

     

3 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    CarlBlunck 

     

    Hope all is well.

     

    A few reasons for this could be to do with the current structure of your data model and the relationship structure as well as the bi-directional approach being taken.  

     

    If you can provide a bit of sample data, it will be easier for the Community to assist and provide reasoning for the cause.

     

    Thanks heaps,

    Theo

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi CarlBlunck ,

     

    Would you mind providing the formula of this measure and the error message? 

     

    Power BI is designed to work with a Star Schema, and a good model is half the battle. 

    Understand star schema and the importance for Power BI

     

    Documentation that may help:

    Adjusting Cross filter direction for a complex set of tables and relationships

    Relationship troubleshooting guidance - Power BI | Microsoft Docs

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data

    • CarlBlunck's avatar
      CarlBlunck
      Resolver I
      4 years ago

      Hi Anonymous 

       

      Measure is:

      Measure 1:
NumberOfApplicants = DISTINCTCOUNT(fact_PageUpApplicantData[ApplicationNumber])

Measure2:
NumberOfApplicantsHired = 
CALCULATE ([NumberOfApplicants],
   fact_PageUpApplicantData[ApplicantStatusMapping.MasterApplicantStatus] = "Hired"
)

      Error only appears when I am trying to include data from all tables in the one visual.  If I limit the visual to only contain data from two of the tables, no problems.