Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HELP - Counting multiple columns containing text

Hi,    Thanks in advance for taking a look at this. Im sure its simple but no calclulations seem to be working for me.        I have several columns labeled License.1, License.2, License.3 ect ...
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

You could create a column as follow:

.USMI = 
COUNTROWS(
FILTER(
RELATEDTABLE('Hilda Test Power BI Data'),
'Hilda Test Power BI Data'[License.1] = ".USMI"))+COUNTROWS(
FILTER(
RELATEDTABLE('Hilda Test Power BI Data'),
'Hilda Test Power BI Data'[License.2] = ".USMI"))+COUNTROWS(
FILTER(
RELATEDTABLE('Hilda Test Power BI Data'),
'Hilda Test Power BI Data'[License.3] = ".USMI"))


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.