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
Solved! Go to Solution.
@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 , 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.
I am not able to share pbix ,but below is data
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
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!