Forum Discussion

SaiK's avatar
SaiK
Helper I
1 year ago

Table Visual unable to load data despite having fewer rows.

Hi, I have two table visuals in a report on the same page in power bi desktop. I have applied pagination to both the tables with the display of items set to 25. Each table displays 25 items on each ...
Need Help
Show and Tell
Tips and Tricks
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi SaiK ,
Please share the generic Dax's used on tha table

SaiK's avatar
SaiK
Helper I
1 year ago

DEFINE
  VAR __DS0FilterTable = 
    TREATAS({"180 Days"}, 'slicer'[Values])

 

  VAR __DS0FilterTable2 = 
    TREATAS({25}, 'Items'[Items])

 

  VAR __DS0FilterTable3 = 
    TREATAS({1}, 'Pages'[Pages])

 

  VAR __ValueFilterDM0 = 
    FILTER(
      KEEPFILTERS(
        SUMMARIZECOLUMNS(
          'TableB'[Column A],
          __DS0FilterTable,
          __DS0FilterTable2,
          __DS0FilterTable3,
          "Measure A", 'Table B'[TMeasure A],

          "Item_Filter", IGNORE('Table B'[Item Filter])
        )
      ),
      [Item_Filter] = 1
    )

 

  VAR __DS0Core = 
    SUMMARIZECOLUMNS(
      'Table B'[Column A],
      __DS0FilterTable,
      __DS0FilterTable2,
      __DS0FilterTable3,
      __ValueFilterDM0,
      "Measure A", 'Table B'[Measure A]
    )

 

  VAR __DS0PrimaryWindowed = 
    TOPN(501, __DS0Core, [Measure A], 0, 'Table B'[Column A], 1)

 

EVALUATE
  __DS0PrimaryWindowed

 

ORDER BY
  [Measure A] DESC, 'Table B'[Column A]

  • SaiK's avatar
    SaiK
    Helper I
    1 year ago

    Query (8, 13) A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

    Got this error

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Hi SaiK ,

    try to update your DAX to look like bellow, this avoid using summirecolumnns twice and improve the perfomance:

    DEFINE
    VAR __FilteredTableB =
        CALCULATETABLE(
            'Table B',
            TREATAS({"180 Days"}, 'slicer'[Values]),
            TREATAS({25}, 'Items'[Items]),
            TREATAS({1}, 'Pages'[Pages]),
            'Table B'[Item Filter] = 1
        )

    VAR __DS0Core =
        SUMMARIZE(
            __FilteredTableB,
            'Table B'[Column A],
            "Measure A", 'Table B'[Measure A]
        )

    VAR __DS0PrimaryWindowed =
        TOPN(501, __DS0Core, [Measure A], DESC, 'Table B'[Column A], ASC)

EVALUATE
    __DS0PrimaryWindowed

ORDER BY
    [Measure A] DESC, 'Table B'[Column A] ASC
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    Sorry about that, use filter instead:

    DEFINE
    VAR __FilteredTableB =
        CALCULATETABLE(
            'Table B',
            TREATAS({"180 Days"}, 'slicer'[Values]),
            TREATAS({25}, 'Items'[Items]),
            TREATAS({1}, 'Pages'[Pages]),
            FILTER('Table B', 'Table B'[Item Filter] = 1)  // ✅ Fixed filter
        )

    VAR __DS0Core =
        SUMMARIZE(
            __FilteredTableB,
            'Table B'[Column A],
            "Measure A", 'Table B'[Measure A]
        )

    VAR __DS0PrimaryWindowed =
        TOPN(501, __DS0Core, [Measure A], DESC, 'Table B'[Column A], ASC)

EVALUATE
    __DS0PrimaryWindowed

ORDER BY
    [Measure A] DESC, 'Table B'[Column A] ASC
  • SaiK's avatar
    SaiK
    Helper I
    1 year ago

    Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.