Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Table shows no data with 0

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    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
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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!

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

Anonymous,

 

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
)