Fix the Totals in Power BI

Hi there, As discussed in our last blog, we observed a scenario where we have to hide totals from one of the columns and meanwhile we discovered that the totals that we have below are displaying a wrong value. Well, Let’s jump into our next section to quickly resolve it in a quick and easy way.

Scenario: Column – No. of Brand has all the distinct no. of brands for each StoreName and We observe that the totals below is showing a wrong value.

Objective: To display the Correct Totals in new columns with the same values.

Step1: Create a Simple Measure for DisitnctBrands as follows:

Step 2: Use the above measure as shown below:

 And we have our desired output ready! Thank you for reading!

Raksha Gangwal

Data Analyst

Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.