Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

how to create pagination using DAX query

I have three tables, all are related and i am doing group by on specific columns.   I am able to get the data but now i want the pagination to be appilied on this using dax query. Can any one help o...
Need Help
prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
8 years ago

Hi Anonymous,

 

Check out this visual. It might help.

 

Prateek Raina

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi prateekraina,

 

Thanks for the reply.

 

I need the DAX query for that.

  • prateekraina's avatar
    prateekraina
    Icon for Memorable Member rankMemorable Member
    8 years ago

    Hi Anonymous,

     

    The visual itself handles the pagination.

    What extra do you want to achieve, can you kindly exoplain a bit?

     

    Prateek Raina

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi prateekraina,

       

      That's right but i want the dax query to be called from the c# using ADOMDClient and retrive the data based on the pagination. 

      • prateekraina's avatar
        prateekraina
        Icon for Memorable Member rankMemorable Member
        8 years ago

        Wait...What !!

         

        The question you posted initiallty is very far from what you have replied now.

        It would be better if you can explain what are you doing.

        Try to tell the problem statement clearly so that people can help you.
        For example:
        1. From where are you pulling data from?

        2. Why do you want to call DAX from C#? What benefit will it provide?

        3. What do you intend to do with the data when pullled from c#?

         

        Prateek Raina