How to Create Table Visual from Measure??

[Txtcher]

I am new to designing visuals in Power BI, and still pretty green with DAX. 

I have this measure to count the number of backlog RS Cases:

Backlog = 
 VAR vSvyDate = LOOKUPVALUE('RS Events'[Survey_Date__c],'RS Events'[Id],SELECTEDVALUE('RS Cases'[RS Event ID])) 
 RETURN
 CALCULATE(
    COUNTROWS('RS Cases'),
    SUMMARIZE('RS Cases','RS Cases'[Program]),
    FILTER(
        ALL('RS Cases'),
        ('RS Cases'[Due By]<=Max('Calendar'[Date]) && 'RS Cases'[Status]="OPEN") ||
        ('RS Cases'[Due By]<=Max('Calendar'[Date]) && 'RS Cases'[Status]="CLOSED" &&
        vSvyDate> Max('Calendar'[Date])) ||
        'RS Cases'[Due By]<=Max('Calendar'[Date]) && ISBLANK(vSvyDate) &&
        'RS Cases'[Status]="CLOSED" && 'RS Cases'[Status Change Date]>max('Calendar'[Date]))
    )

It works wonderfully and I have used it to create a bar chart.

But what I want to do now is create a table visual below the chart showing details of the rs cases that are backlogged. Essentially, I want to display selected columns from the RS Cases table, and filter the table to show what the bar chart shows for backlog only (not sent to Region). 

Thanks in advance.

[Txtcher]

Thank you! That was something new for me - creating a table. (Yes, I am very new to PBi.)

So how can I link a slicer that uses a field from the parent table? The newly created table (Backlog Cases) does not have a relationship with RS Cases (the parent table). 

[burakkaragoz · Accepted solution]

Hi @Txtcher ,

If you're trying to create a table visual that shows only the RS Cases that are backlogged (and not sent to Reopen), you don't need to build the entire logic inside a measure. Measures return scalar values, not tables — so they can't directly generate a table visual.

Here’s what you can do instead:

1. Use a calculated table if you want to pre-filter the data model:

BackloggedCases =
FILTER(
    'RS Cases',
    'RS Cases'[Status] = "CLOSED"
        && ISBLANK('RS Cases'[Reopen Date]) // or whatever field indicates it's not reopened
)

1. If you want to do it dynamically in a table visual, just:

   • Add the columns you want from RS Cases (like ID, Status, Survey Date)
   • Add a visual-level filter:
     • Status = "CLOSED"
     • Reopen Date is blank (or whatever field you use to track reopen)

2. If you still want to use a measure to highlight or flag backlog cases, you can write something like:

IsBacklog = 
IF(
    'RS Cases'[Status] = "CLOSED" && ISBLANK('RS Cases'[Reopen Date]),
    1,
    0
)

Then filter the table visual where IsBacklog = 1.

Let me know if you want help building a calculated column or table based on more complex logic.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI