How to change the value shown in the column

[Anonymous]

Hi,

Each row in my table is a sales lead. It is connected to my Customer[Dimensions] table. I have a DistinctCount() that counts the total customers we define as "Platform Accounts". In my report I have a Matrix Table which shows the list of those customers:

How do I show the "1" as another value - ie.: I would like it to say "is a platform account" or simply "Yes"

[JarroVGIT · Accepted solution]

Hi @Anonymous 

You might want to use an IF() statement in the measure that you use with your DISTINCTCOUNT(). Something like

IsPlatformAccount = IF(DISTINCTCOUNT(Table[Column]) > 1, "Yes", "No")

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂