Grouping and Calculations using existing semantic model

Hi prutia ,

In Power BI, when you use a published semantic model as a data source for your reports, the model serves as a single source of truth. This means that while you can use the model across multiple reports, the ability to add report-specific groups or calculated columns directly within the semantic model is limited. 

If your semantic model is hosted in Analysis Services or Power BI Premium with XMLA endpoint access, you might consider using calculation groups. Calculation groups allow you to define reusable calculations that can be applied across multiple measures without creating individual calculated columns for each scenario. This feature can help keep your model streamlined while providing flexibility for report-specific calculations. More information on calculation groups can be found here: Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.