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