Forum Discussion

harirao's avatar
harirao
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 ...
Need Help
Show and Tell
Tips and Tricks
  • v-kelly-msft's avatar
    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!

     

harirao's avatar
harirao
Post Prodigy
6 years ago

Hi v-kelly-msft 

I am getting error while creating measure, as mentioned 


Regards,
Hari

harirao's avatar
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's avatar
    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!