Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
created below measure and it is working
created below measure and it is working
@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])
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
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |