Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Using measure as filter causes visualisation to hang

Hello,   I have a measure in a visualisation filter, so that I can select only records that are in a date range (selected in a slicer) (i.e. count = 1). The measure uses USERELATIONSHIP to link the...
Need Help
bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

If you've built a test pbix file can you share it anyway? Realise the speed issue won't be present but it will show us how your model is setup.

 

I'm assuming in your main pbix file you have a much larger amount of data. Your visual filter measure is then being triggered for every single row. What we need to do is see if we can optimise that code or alter the model to speed it up but would need to see more to help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi bcdobbs this is the test file https://file.io/nTOMlGKdIih3 

     

    I have a lot of other measures in the 'live' file's table, which I expect is the problem. But I'm looking for a method to establish what the exact problem is 🙂

     

    Thanks

    • bcdobbs's avatar
      bcdobbs
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Thanks Anonymous .
      So to confirm my understanding you're wanting the visual to display orders that were either ordered in the selected date range or delivered in the selected date range?

      How many rows does your real Sales table have?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi bcdobbs the real datatable has about 300,000 rows

         

        The live file only hangs when I introduce the filter measure (i.e. the equivalent of the measures "Measure" or "Measure 2" in the test file I posted)