Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everybody and apologies in advance if I'm missing something really simple. (Just haven't been able to find a solution elsewhere).
I want to filter the ateendees of a conference and then also show the activities that correspont to each ateendee, the model goes as follows.
The first filter works, i got the ateendees of the event, but as soon as i add the activities only shows the Ateendees that have activities. I would like to show all and if the attendee does not have any activities shows 0.
In this case for example, I got an event with 9 attendees:
As soon as i add the activities the result is as follows (only 7 that are the ones that has an activity):
As i mentioned i would like to show all 9 (7 with the number of activities and 2 with a 0 instead of disappear). I tried adding a measure with an IF search for ISBLANK and adding a 0 instead, but it return all the Ateendees (not only the ones in the event) with a 0.
Thanks for any help!
Solved! Go to Solution.
Hi,
Have you tried to tick the 'Show items with no data' on your Attendeee_Name Column in your visual ?
If, you did and the issue still remains, would you please share some sample data to figure it up ?
Appreciate for Kudos.
Hi,
Have you tried to tick the 'Show items with no data' on your Attendeee_Name Column in your visual ?
If, you did and the issue still remains, would you please share some sample data to figure it up ?
Appreciate for Kudos.
Perfect! That works, sorry sometimes you get blind with this simply things. Really appreacite the help!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |