Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
s0m0ffc
Regular Visitor

Dax query dependency

Hi All,

 

I have an application that depends on DAX query to show the different KPIs for month, quarter, daily. With more reports and KPIs it becomes tedious to maintain DAX queries. Is there a way to avoid dependency on DAX and pull the data from datasets or reports in an alternative way. Please suggest some solution where the dependency is minimised or maintenance becomes easier

8 REPLIES 8
v-sgandrathi
Community Support
Community Support

Hi @s0m0ffc,
Thank you for reaching out to the Microsoft Fabric Community forum.

 

We suggest Centralized Data Model with Pre-Aggregated Data works here instead of DAX. Build a single, well-structured data model in Power BI that contains all core KPIs (like: Monthly, Quarterly, and Daily Metrics) and use reusable DAX measures and calculation groups to standardize logic in reports.

Then prepare datasets with pre-aggregated metrics using ETL tools like Power Query or SQL so that this minimizes the dependency on DAX and improves report performance. Connect all reports to the centralized dataset, ensuring consistency and enabling faster report creation.

After, Use Calculation Groups in Power BI to apply time-intelligence logic (e.g., Month-to-Date, Quarter-to-Date) dynamically, avoiding repetitive DAX code across multiple measures.

 

I am attaching the Microsoft Calculation groups link, if you want you can go through it and get an idea of it which may fit your further requirements.

Create calculation groups in Power BI - Power BI | Microsoft Learn

 

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more easily.

 

Best Regards,
Sahasra.

Hi @s0m0ffc,

 

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

 

Regards,
Sahasra

Hi @s0m0ffc,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Sahasra.

Hi @v-sgandrathi - Thanks for your suggestion. But it may not work out as each report belongs to different datasets and its owners are also different. I am looking out for solutions which can dynamically generate dax or pull the numbers from powerbi report without dax

Hi @s0m0ffc,

 

As you mentioned each report belongs to different datasets and their owners are also different here are the workarounds which may work for your requirements.

  1. You can avoid using DAX by leveraging SQL queries or Direct Query mode. If your datasets are stored in SQL or another common database. Then, write reusable SQL queries or views to dynamically calculate key performance indicators (KPIs). Use Direct Query mode in Power BI to connect directly to the database.
  2.  Paginated Reports enable dynamic data retrieval from multiple datasets. To create         these reports, first install Power BI Report Builder. Then, connect directly to multiple   datasets within the report builder. Use parameters to dynamically fetch key   performance indicators (KPIs) from these datasets.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more easily.

 

Best Regards,
Sahasra.

 

Hi @s0m0ffc ,

I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

 

Regards,
Sahasra.

Hi @s0m0ffc,

 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Sahasra.

Hi @s0m0ffc,

 

Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!

 

Thankyou.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.