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 all,
I'm having a trouble with the table that I'm using in my report.
The data that I received is the following:
There is also a 'Person D' wich has no active devices on his name.
Now what I want is an Table where also the following is shown:
Agent Number of active devices
Monten Joris 3
Person A 3
Person B 4
Person C 2
Person D 0
Now i've created the table by using the count(distinct) but then Person D isn't shown becaus of the value 0.
Is there an way to let Person D also shown in the table?
The option 'Show data with no data' isn't an option.
Thanks!
Solved! Go to Solution.
You may refer to the following DAX that creates a new table.
Table = SUMMARIZECOLUMNS ( Table1[Agent Name], "Count", CALCULATE ( DISTINCTCOUNT ( Table2[Active Devices] ), FILTER ( Table2, Table2[Agent Name] = MAX ( Table1[Agent Name] ) ) ) + 0 )
Try creating a measure that counts the instances of each agent you have and stick +0 on the end of it?
Can you be my guidance for this?
I've just seen this as a work around for a few things where a visual shows as blank - I assume you've got your agents in some sort of related table to the data you displayed, if you look up how the countrows function works and run that across your data that should be a starting point
measure = if(isblank(measure, 0, sum(measure))
or + 0 on the end
Proud to be a Super User!
Maybe I wasn't cleared enough in my posts sorry about that.
I've got 2 data sources, the first contains all the employees and their team. The second one contains all the number of active devices on their name.
I've created an 'inner join' from those 2 tables (Active devices on employees).
This results in an table where only the employees with one or more active devices on their name are show.
Due to this the agents aren't shown in the table that I use in my report.
Is there a possibility that all agents that are in the data source (employees and their team) are shown in any way together with the sum(distinct) off the active devices on their name. And for the employess without any devices on their name an 0 is shown?
Thanks!
You may refer to the following DAX that creates a new table.
Table = SUMMARIZECOLUMNS ( Table1[Agent Name], "Count", CALCULATE ( DISTINCTCOUNT ( Table2[Active Devices] ), FILTER ( Table2, Table2[Agent Name] = MAX ( Table1[Agent Name] ) ) ) + 0 )
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |