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
Rajeshwari Sharma
Rajeshwari is an experienced data professional with a track record of using data-driven insights to improve business performance. She has successfully managed multiple projects, utilising her expertise in data analysis and database administration. As a Microsoft-certified Data Analyst and Azure Database Administrator, she has cultivated a deep understanding of data management best practices and advanced analytics techniques. Her MBA in Business Analytics has equipped her with a solid foundation for integrating business strategy with data insights.
