Forum Discussion

Avivek's avatar
Avivek
Post Partisan
4 years ago

Issue with the filled map

I have been facing an issue with the filled map, 

 

If you see the above 2 maps then we can see that there is a difference in the values between the filled map and matrix visual but the normal map matches with the matrix visual.

Also on further checking we can see that in the filled map if we add the no of accounts in the longitude then value matches with the matrix. The no of accounts is a measure which is:

No of Account = CALCULATE(DISTINCTCOUNT(ACCOUNT[PARENT ACC NAME]),ALLEXCEPT('DATE','DATE'[DATE]))
Here we use allexcept in the measure because we have 2 slicer's for from year and to year.
I would like to know why the map is filtering only on adding the nos of accounts in the longitude and secondly why it is showing in the map but not in the filled map.
It will be great if someone can help me on this.
 

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Avivek , if you want from year andto year, one of them should be an independent table or both should from two-year tables(not joined) and they filtered like

     

     

    //Year1 and Year2 are independent Year tables, Date is joined with Table
    new measure =
    var _max = maxx(allselected(Year1),Year1[Year])
    var _min = Minx(allselected(Year1),Year1[Year])
    return
    calculate( sum(Table[Value]), filter('Date', 'Date'[Year] >=_min && 'Date'[Year] <=_max))

    • Avivek's avatar
      Avivek
      Post Partisan
      4 years ago

      The To Year is an idependent table and To Year and From Year slicers seems to work otherwise fine. 

      But I want to understand how it is filtering by adding the measure in the longitude.

      Also another way I could see was when we click on Show Items with no data for Account Name. This works and makes more sense to me.

      But I do not understand how adding the measure in longitude is working. 

      And also how it works for a map but not for a filled map, unless we apply Show Items with no data in the filled map.