Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Average Measure function changes from Power BI to Power BI report builder tool

I have created a quick measure in power bi which gives me average value of daily trade biffurcated among month, quarter & year. However, when i link my dataset with power bi paginated report builder tool the same measure does not gives me average and instead it totals up. So in the visual of paiginated report builder tool. It gives me monthly average and then in quarter and months its just the total of all months instead of average. What is that step which i need to perform in paginated report builder tool that can give me the exact result which is there in Power BI.

 

 

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support

    Hi Anonymous 

     

    Can you please show the DAX code of the quick measure? And can you provide some sample data and expected result so that I can try to reproduce this problem at my side? Thanks.

     

    Best regards,

    Jing