powerbi - How do I use GenerateSeries with a dynamic end value? - Stack Overflow

时间: 2025-01-06 admin 业界

I am trying to create a table that returns all the items that were filtered out by slicers in my report. However, my GENERATESERIES portion of the table is not executing properly, and I could use some assistance. Here is the calculated table formula:

FilteredOutItemsTable = 
  ADDCOLUMNS(
    GENERATESERIES(1, PATHLENGTH(SUBSTITUTE(ConcatenatedString, ", ", "|"))),
    "Item", PATHITEM(SUBSTITUTE(ConcatenatedString, ", ", "|"), [Value])
  )

I did ensure that the ConcatenatedString is returning the correct value as well as the PATHLENGTH portion of the formula.Not sure where to go from here.