How to Create Table Visual from Measure??

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