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 

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