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 ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need use and or OR ?

 

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