Forum Discussion

Roym's avatar
Roym
Icon for Helper IV rankHelper IV
4 years ago
Solved

Unique and not unique count

I have a table in my dataset with Issues and Findings per Reporting Entity. The count of those are added in a table (see screenshot below. In this case two issues are linked to both reporting entity ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    You can't add two "total" rows, but you can concatenate two result together like this.  This will give the two results on all rows, but you can use IF(HASONEVALUE() or ISFILTERED() to show two results only in the "total".

     

    Unique/Not Unique = 

    var u = <unique expression>

    var n = <not unique expression>

    return u & "/" & n

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You can't add two "total" rows, but you can concatenate two result together like this.  This will give the two results on all rows, but you can use IF(HASONEVALUE() or ISFILTERED() to show two results only in the "total".

 

Unique/Not Unique = 

var u = <unique expression>

var n = <not unique expression>

return u & "/" & n

 

Pat

 

Roym's avatar
Roym
Icon for Helper IV rankHelper IV
4 years ago

Great, thanks!!