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 Power BI partner based in Mumbai, India. Apart from being authorized for Power BI implementations, Addend has successfully executed Power BI 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 at kamal.sharma@addendanalytics.com.