Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Map showing incorrect count but table is correct

I have a map that should show the number of issues per location for the selected time frame.  I have the following measure:

P1P2 Count = CALCULATE(COUNTROWS('Incidents'),('Incidents'[Priority]="1 - Critical" || 'Incidents'[Priority]="2 - High")
which properly counts the number of issues per location.
 
I have another measure intending to show the text of the Short Location followed by the P1P2 Count for that location for the date range selected by the user :
P1P2s by Location = 'Incidents'[Short Location] & ": " & CALCULATE([P1P2 Count],ALLEXCEPT('Incidents','Incidents'[Short Location],'Incidents'[Created]))
 
The problem is my map is showing a count of 1 for each location (at least one of the locations has 5).  When I click Show as Table, I get the proper counts.
 
Can someone help me fix the P1P2s by Location formula?
 
 
 
 
 
Need Help

13 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous Your India location is showing 5 represented by the larger circle size.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Right but the label is showing Bangalore, India:  1

      • LaasyaS's avatar
        LaasyaS
        Icon for Microsoft Employee rankMicrosoft Employee
        2 years ago

        Did you ever figure this out? I am experiencing the same issue

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

    it may have something to do with  CALCULATE([P1P2 Count],ALLEXCEPT('Incidents','Incidents'[Short Location],'Incidents'[Created])).

    what's the content of [P1P2 Count]? and could you share sample of related sheets?

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The first pink formula shows how I got the value of P1P2 Count.  The second formula seems to be counting the distinct Short Locations (thus, each location is counted once).  What I need it to do is show the count of P1P2s for each location like it does in the table.

       

      So, since there were 5 separate incident tickets created for Bangalore, the map label should read "Bangalore, India: 5".

       

      I'm not sure what sheets you are asking for.

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous 

        I mean, could you share your sample data or sample file? tks

        besides,

        P1P2s by Location = 'Incidents'[Short Location] & ": " & CALCULATE([P1P2 Count],ALLEXCEPT('Incidents','Incidents'[Short Location],'Incidents'[Created]))
 
The problem is my map is showing a count of 1 for each location (at least one of the locations has 5).  When I click Show as Table, I get the proper counts.

        not sure how you put the measure into Category label, in my test, I can only put column into it.

        Looking forward to receiving your reply.

         

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    What result do you get with this

    P1P2s by Location = 'Incidents'[Short Location] & ": " & [P1P2 Count]

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Ashish,

      I got the same result as shown in the original screenshots (so, if there is no difference, the simple formula is best) but it still is not correct.

       

      Please keep trying.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        I will need to see your file then.  Share the download link and clearly show the problem there.