Forum Discussion

wbhite's avatar
wbhite
Helper I
3 years ago

Issue with measure that includes a hard-coded value

Hello all,

This is going to be rather vague since I have a large data model and it would be cumbersome to share, but I'm hoping if I outline my issue that someone could give me general guidance on what to check.  Below are the key elements, generalized:

 

  • I have a Products dimension table connected to a Sales fact table.
  • I have a visual that shows various fields from the Product table (one of which is "Sq Ft") as well a a Sales measure (SUM from the fact table).  This all works fine.
  • I need to add a new measure:  MYMEASURE = 0.05*Products[Sq Ft]
  • When I add this new measure to the visual, PBI Desktop spins and consumes all local resources until eventually failing with "there's not enough memory to complete this operation."

Again, I know this is vague, but any suggestions?  Thanks!

Need Help

3 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this


    MYMEASURE = 0,05 * SUM(Products[Sq Ft])

    • wbhite's avatar
      wbhite
      Helper I
      3 years ago

      Thanks, but I didn't type my example measure out correctly.  I am using the SUM function (PBI would produce an error if I didn't wrap it up in a aggregation function).

      • kpost's avatar
        kpost
        Solution Sage
        3 years ago

        I'm no expert in making dashboard more efficient and use less data but the first thing I'd try is just adding a new column that is equal to 0.05*[sq ft].

        then in your visual, just add that column and make sure summation is 'on'

        If that doesn't work... well, good luck haha.  

        //Mediocre Power BI Advice, but it's free//