Forum Discussion

spagad6263's avatar
spagad6263
Icon for Post Patron rankPost Patron
3 years ago

Table Total appears unpected

Hi, I would like to show a table total (NOT matrix) like below (sample in Excel). 

 

When the field [Name] is changed to Count, the whole column is now changed to 1, instead of the actual column info. Any suggestions?

 

 

 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    spagad6263 you need to add a measure and use this in the visual 

     

    Measure =
IF ( HASONEVALUE ( Table[Id] ), MAX ( Table[Name] ), COUNTROWS ( Table ) )