POWERBI : Show Amount greater than zero on Map

[khush19]

Hi ,

I am working with Mapbox in POWERBI and mode is PUSH ataset so only can create Measure .

In my scenario suppose,

8 AM  0$,-37.8136 and 144.9631 (send to powerBI as no transaction Happened and latitude and longitude are customer specific to show centrepoint on map)

9 AM 10$,-37.802730930983344,144.96049156624548 (send to powerbi )

10AM 20$,-37.80273093098666,144.96049156624599  (send to powerbi )

So if amount greater than 0 is send i dnt want 0$ to be shown on Map, means i dnt want (0$,-37.8136 and 144.9631) to be shown on POwerBI.

Problem I am facing as in PUSH dataset i can only write measure .

I tried to create a measure where

if sum is greater than 0 and individual amount is greater than 0 then return amount  

AmountUpdated = IF(x[Amount]>0,MAXX(FILTER(x,x[Amount]>0),x[Amount]),MAXX(x,x[Amount]))

But still on map i see record for 0$

[khush19 · Accepted solution]

created below measure and it is working

CentrepointAmount =

if(CALCULATE(SUM(X[Amount]),ALLSELECTED(x))>0,

if(x[Amount]>0,x[Amount],BLANK()),x[Amount])

[amitchandak]

@khush19, have you tried a visual level filter of >0 

or a measure like add all group to summarize and use the measure you want

maxx(filter(summarize(Table, Table[Map Group1], Table[Map Group2], "_1", [Measure]), [_1]>0), [Measure])

[khush19]

HI Amit,

I cann't apply Visual level filter as for some customer we can have no transaction, So 0$ on map will show centrepoint on map

[amitchandak]

@khush19 , then you have to try with summarize with appropriate filters.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[khush19]

Hi Amit,

I am not able to share pbix ,but below is data

CustomerId	Amount	Latitude	Longitude	Hour
A	10	-37.8136	144.9631	7:00
A	30	-37.813645	144.96314	6:00
A	0	-37.813623	144.9631331	5:00
B	0	-36.8136	143.9631	5:00

Now when i show on map ,i use Amount,latitude,longitude

for Customer A as we have Amount >0, then we dnt want row 3 to be shown on map

but for customer B as there is no amount >0 then we want to show row 4 on MAP