Count the number of cases a specific value is shown from a measure

[andrewb95]

I have two tables both are showing the ID and longitude and latitude for a specific item. One table shows this for a home address and another shows this for a specific store. 

I have then used https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-h... to plot the distance between each point in a measure. 

I want to calculate the count of  Sub ID's which have an value beneath 80. As you can see I have added conditional formatting to show this at the moment. 

[v-yingjl · Accepted solution]

Hi @andrewb95 ,

Sorry for replying late. Based on your description, you can create this measure to count:

Count = 
COUNTX (
    FILTER (
        SUMMARIZE (
            ALL ( 'Table' ),
            'Table'[TenantId],
            'Table'[Customer ID],
            'Table'[Store ID],
            "Re", [Measure]      //your measure to calculate the sub
        ),
        [Re] < 80
    ),
    [Re]
)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@andrewb95 , Try a measure like

countx(filter(summarize(Table, table[tenant_id], table[Store_id], "_1",[Distance measure]),[_1]>80),[tenant_id])