Forum Discussion

fvdyoshida's avatar
fvdyoshida
Frequent Visitor
4 years ago

Average calculation showing incorrect values

Hello everyone.   I  have a report that consolidates Metric information from several vendors. There is a common columns called Metric where I have all Metrics scores    Metric_ID Score Users...
DAX
DAX. CALCULATE
fvdyoshida's avatar
fvdyoshida
Frequent Visitor
4 years ago

Hi Vahidm,

 

I am trully sorry I send a very example that does not represent my issue well. I will try to refrase the question .

 

I have in this example 3 tables from different metrics that I aggregate into one, since this one will be used into the report with all info, were I should be able to filter by country/user and see the metrics % and value for the filters or all data if no filter is selected.

 

the metrics are coming from different tables because:
1) they come from different vendors
2) they have different rational to calculate (the formas will vary )

 

The biggest problem is that once I place the data into a table visual the value and metric columns should show the results based on the metric criteria, average for MT-01 & MT-02 OR count for MT-03. However I can only set these fields on average or sum, so when I have average I got right results to averaged based metrics but wrong to count/sum metrics, and vice-versa.

i upload the test pbix file here for reference:
https://1drv.ms/u/s!Am4oytAhDwtXah2WbDEJhqgYMFo?e=66PHzM

 

thank you so much

Fabio

Fabio

 

 

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, fvdyoshida 

    The biggest problem is that once I place the data into a table visual the value and metric columns should show the results based on the metric criteria, average for MT-01 & MT-02 OR count for MT-03. However I can only set these fields on average or sum, so when I have average I got right results to averaged based metrics but wrong to count/sum metrics, and vice-versa.

    Probably due to no relevant work experience, after reading the above posting many times, I still can't tell what you are looking for, how to understand the average of MT1 and MT2 or the count of MT3?
    Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented? 

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng

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