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, thi...
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

     

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.