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
)
jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Try creating a measure that counts the instances of each agent you have and stick +0 on the end of it?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Can you be my guidance for this?

    • jthomson's avatar
      jthomson
      Icon for Solution Sage rankSolution Sage
      8 years ago

      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

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        8 years ago

        measure = if(isblank(measure, 0, sum(measure))

         

        or + 0 on the end