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 -...
Need Help
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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Xiaotang,

      The category label is the "P1P2s by Location" field which is a column calculation.  So it serves a dual purpose:  To identify the locations themselves and what the label should read.

       

      I learned this from Mitchell Pearson's video titled "How to add Data Labels to Maps in Power BI! Tips and Tricks":

      https://www.youtube.com/watch?v=4ZOanVP1PS0