Forum Discussion

Ghaston's avatar
Ghaston
Helper I
7 years ago
Solved

problem with filtring

hi  i'm using Direct Qid_uery and i'm having a hard time filtring my date with "CALCULATE" function.  I have a Column "ID_OF", and i want to run the result juste for the highest value of "ID_OF".  ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Ghaston,

     

    Actually when you were calculating last_of in your variable that is dynamic and you provide a scenario where you are fixing a fixed value like 12198.

    So in variable also you have to do same, by filtering all table data.

     

     

     

    Hope this will solve your problem. i have also sent you pbix file.

     

    Best Regards,

    Ravi

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ghaston

 

Could you please some temp data for it or pbix file?

 

 

Regards,

Ravi

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Ghaston

     

    Please find the drive link for the Solution. Test.pbix.

     

     

    Best Regards,

    Ravi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Ghaston,

       

      Actually when you were calculating last_of in your variable that is dynamic and you provide a scenario where you are fixing a fixed value like 12198.

      So in variable also you have to do same, by filtering all table data.

       

       

       

      Hope this will solve your problem. i have also sent you pbix file.

       

      Best Regards,

      Ravi

      • Ghaston's avatar
        Ghaston
        Helper I
        7 years ago

        hi Anonymous

        That worked perfectly!
        Thanks.,
        But i didn't understand why my code didn't work. Can you explain that for me please? i would appreciate it