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
Author By
Kamal Sharma
Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.
