Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Rewrite Filter function with better option (Optimize Dax Measure)

Hi Guys! I need your help please, I have a model and I need to calculate a Sum of a column as a measure, the measure works fine, shows me the correct number, but when I begin to use other dimension...
DAX
optimize
  • Anonymous's avatar
    Anonymous
    6 years ago

    I can solve it using lastnonblank function, everything works fine now

Anonymous's avatar
Anonymous
Not applicable
6 years ago
OK. How many rows are you pulling out in total?

Best
D
Anonymous's avatar
Anonymous
Not applicable
6 years ago

4371 rows (including the total), if I put all dimensions of the model, the result will be bigger, the fact table has 730K rows.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Yeah... This is a lot of rows. For a reporting tool that should summarize data, this is really unusual to return that many rows. Also, the speed depends on the hardware you use.

    I suppose that for a decent amount of rows the measure will be very fast.

    Best
    D
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    But everything works fine if I remove the Date filter, this one:   FILTER ( 'Date', maxMonthid = 'Date'[Month ID] )

     

    Obviously, the result of the measure doesn't work for me.  So, there is another idea to replace it?