Forum Discussion

Post Prodigy

6 years ago

Solved

Total not Matching

Hi All, After including DISTINCTCOUNT & Filter in measure, Total is not coming correctly. Correct total is 209, but getting 206 61 31 27 25 17 16 11 7 7 7 ...

Tips and Tricks

v-kelly-msft
6 years ago
Hi harirao ,

It's a subtotal issue,pls add a measure as below:

_%6week_1&2 = SUMX(SUMMARIZE('Query1','Query1'[subregion]),'Query1'[%6week_1&2])

And you will see:
For the related .pbix file,pls click here.

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Community Support

6 years ago

Try to add a measure as below:

measure=sumx(summarize('table',[subregion],"%6",[%6week_1&2],[%6])

Check whether it works.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

harirao
Post Prodigy
6 years ago
Hi v-kelly-msft

I am getting error while creating measure, as mentioned

Regards,
Hari
- harirao
  Post Prodigy
  6 years ago
  Hi v-kelly-msft
  
  I tried with below measure, was able to fine that three subregion having same ID which is creating issue for WW
  Correct Answer is 89(59+9+21)
  
  Other Subregions are getting correct answer (15+19+5+27+6+28+7=107)
  
  Measure of %6week_1&2
  %6week_1&2 = CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]), FILTER(Query1, Query1[actual_visibility_weeks]> 0))
  +
  CALCULATE(DISTINCTCOUNT(Query1[OpportunityId]), FILTER(Query1, Query1[0 visibility exclusions]= "No"),
  FILTER(Query1, Query1[actual_visibility_weeks]= 0),
  FILTER(ALL(Query1),Query1[1MUSD Flag]=1 && Query1[PipelineExclusionIndicator]="N"))
  
  Can you please help me to get correct result for WW.
  
  Thank you
  
  Regards,
  Hari
  - v-kelly-msft
    Community Support
    6 years ago
    Hi harirao ,
    
    It's a subtotal issue,pls add a measure as below:
    
    _%6week_1&2 = SUMX(SUMMARIZE('Query1','Query1'[subregion]),'Query1'[%6week_1&2])
    
    And you will see:
    For the related .pbix file,pls click here.
    
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

Related content