Hi Ishaan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

Facing the same problem. The day where there are no sales, it is reducing the denominator as well.

Another good option!

Hello @kowusuasante, Yes, this technique can be similarly applied to the non-amount based columns as well. But it's always a bit difficult to assess and recommend without looking at the data structure, model and working of the PBIX file for reference. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZfaq channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

Hello @MoonShine-bs6cl, We're not quite sure about what you're trying to ask here. But yes, averages can be calculated and translated in any form of visual or context. We request you to please elaborate your query by providing a proper description so that we can assist you in a better and efficient manner. For now, we're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZfaq channel pertaining to the topic - "How To Calculate Average In Power BI?". You can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZfaq channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/ kzfaq.info/get/bejne/i8l6YNOYtdaZcqM.html kzfaq.info/get/bejne/jsyFmJxims6sZ6s.html kzfaq.info/get/bejne/g657g8mgs6vddIk.html kzfaq.info/get/bejne/eL9daNqSzrLUYJs.html kzfaq.info/get/bejne/mN-GaqiUubzWp3k.html blog.enterprisedna.co/calculating-averages-per-transaction-using-dax-in-power-bi/ blog.enterprisedna.co/calculate-average-sales-in-power-bi/ blog.enterprisedna.co/calculating-averages-per-day-month-or-year-within-power-bi/ blog.enterprisedna.co/calculating-average-monthly-purchases-in-power-bi-using-dax/

@@EnterpriseDNA Thank you My question is I have calculated the average measure of due date and receipt date it gives me 40.55 as a value, but if I would need the categories wise distribution of average it's giving me same value 40.55 for all the categories which is wrong, so pls could u help me working in this as it should give a seperate averages per category. Hope you understood my question

Hello mandar, We're not able to understand your query here about what do you mean by "plain average"? We hope you please elaborate your query so that we can provide better assistance. In case, if you mean AVERAGE() DAX function V/s AVERAGEX() DAX function then we provide a link of a video which showcases the difference between the agregating functions V/s the iterating function. The video is based on SUM() V/s SUMX() but the explanation remains the same for average functions as well. Along with it, we also recommend you to please go through the beginner's videos which are available at a free of cost to all of our viewers on our KZfaq channel i.e., "Beginner's Guide to Power BI" and "Beginner's Guide to DAX". Below is the link of those courses provided for your reference purposes as well. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our KZfaq channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ kzfaq.info/get/bejne/q8efltB1y5vTdok.html kzfaq.info/get/bejne/nrx9hpipqs7Lnnk.html kzfaq.info/get/bejne/f7KGha2Cl5jHmqc.html