Granular or specific questions

Anonymous Well, the self-service concept is kind of why Power BI exists. Depends on your definition of "large", are we talking thousands, millions, billions or trillions of rows. If it is truly large, you would be getting into DirectQuery and using aggregation tables potentially. Q&A is useful although it is often very important to build out your semantic layer to make this easier on end users. Other than that, it is really important to make the data model easy to understand by end users, hide unnecessary fields, etc. You can allow them to create their own reports very easily in the Service.

Anonymous , I think creating a model is important which can answer most of the questions. I am not sure if Q&A can do everything for you.

A good star schema model with date calendar and required measures should be a good start.

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

Hi Anonymous,

I think Greg_Deckler and amitchandak already shared some tricks and tips for your scenario.
In my opinion, you can also need to consider creating dynamic measure formulas instead of static formulas. (they can interact with slicer/filter selections so that you can reduce the formula amounts in your report)
You need to write dynamic Dax formulas who based on Dax functions and current row content in your expression, then they can interact with selection and filter and change the result dynamically.

Please check following links if they help:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 

DAX – The Many Faces of VALUES() 

In addition, you can change your table structure to achieve the dynamic attribute visual based on slicers.

Dynamic Attributes In A Power BI Report 
Regards,

Xiaoxin Sheng