Hi All, I need to count the number of SSD from the cell below: FriendlyName : Msft Virtual DiskSerialNumber :MediaType : SSDSize : 8589934592FriendlyName : ST3320418ASSerialNumber : 9VMY84KEMediaType : HDDSize : 320072933376FriendlyName : KINGSTON SA400S37120GSerialNumber : 50026B77760184FCMediaType : SSDSize : 120034123776 I created one new column with this line :COUNT SSD = CALCULATE(COUNTROWS(HD_Info);SEARCH("SSD";HD_Info[MACHINE_CUSTOM_INVENTORY_0_19239];;0))But it´s not working 100% correct , the result showed is 1 , not the correct "2" , do you know how can I fix this count to have the correct result ?

LESPINOLA , Dá uma olhada no arquivo: Download PBIX na aba 2. Eu inclui outras linhas, com tamanhos diferentes pra testar.

Count words | Microsoft Fabric Community

Community Champion

Try this code for a measure:

Measure =

VAR _column = SELECTEDVALUE('Table'[Column1])

VAR _text = "SSD"

RETURN (LEN(_column) - LEN(SUBSTITUTE(_column; _text; ""))) / LEN(_text)

Your code didn't work because it's counting the number of rows containing SSD and not each ocurrence.

I've created this file using m code: Download PBIX

I would use this second example (m code).

New Member

Hi Camargos88,

I tried here this measure, but without sucess.

Let me show you one example that I need ! I need create two column , one to count the SDD and other to count HDD like the example below:

TEXT COLUMN	COUNT SSD	COUNT HDD
<br/>MediaType : SSD<br/><br/>MediaType : HDD<br/><br/>MediaType : HDD<br/>	1	2
<br/>MediaType : SSD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/>	3	0
<br/>MediaType : HDD<br/><br/>MediaType : HDD<br/><br/>MediaType : HDD<br/>	0	3
<br/>MediaType : SSD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/>	3	0
<br/>MediaType : HDD<br/><br/>MediaType : SSD<br/><br/>MediaType : SSD<br/>	2	1

Thanks