Forum Discussion

lewisholmes's avatar
lewisholmes
Regular Visitor
3 years ago
Solved

Simple Addition Measure Producing an Error

I have a simple DAX measure which looks like this:   Total = [Calls] + [Meetings]   The two parts [Calls] and [Meetings] are themselves measures and there is a bit of a dependancy tree but ulti...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    Hi lewisholmes ,

     

    It is a limitation:

    Aggregations – The Call Quality Dashboard data model is built on a cube model, meaning that aggregations are already supported in the form of measures. Attempting to manually add aggregations to different dimensions or changing the aggregation type of a measure will not work with the Connector, and it will generally result in an error.

     

    For more details, you can refer this link.

    Install Power BI Connector to use CQD query templates - Microsoft Teams | Microsoft Docs

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
3 years ago

Hi lewisholmes ,

 

It is a limitation:

Aggregations – The Call Quality Dashboard data model is built on a cube model, meaning that aggregations are already supported in the form of measures. Attempting to manually add aggregations to different dimensions or changing the aggregation type of a measure will not work with the Connector, and it will generally result in an error.

 

For more details, you can refer this link.

Install Power BI Connector to use CQD query templates - Microsoft Teams | Microsoft Docs

 

Best Regards

Community Support Team _ chenwu zhu

 

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