how to create pagination using DAX query

[Anonymous]

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 on this.

[prateekraina]

Hi @Anonymous,

Check out this visual. It might help.

Prateek Raina

[Anonymous]

Hi @prateekraina,

Thanks for the reply.

I need the DAX query for that.

[prateekraina]

Hi @Anonymous,

The visual itself handles the pagination.

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

Prateek Raina

[Anonymous]

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]

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

[Anonymous]

@prateekraina,

1. I have web application from there i am trying to pull the data by calling the dax query using ADOMDClient. 

2. I have millions of records in the DB and i want to do the aggregation on that. So Cube will give the result faster than the SQL.

3. I am displaying in the UI

[prateekraina]

Hi @Anonymous,

I strongly feel that you have posted this question in a wrong forum as this forum is about Microsoft Power BI Desktop.

Nevertheless, I found this on the internet related to your query. Might help.

Prateek Raina

[Anonymous]

@prateekraina Thanks for your time 🙂