Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am having a text column as follow
Text
Apple
Carrot
Apple
Carrot
Beans
Kiwi
Beans
Kiwi
I need to create a separate card for each fruit. How to sum the total number of apple or carrot etc present in the column using dax measures?
I need to create separate DAX measures for each fruit.
Please advise
Solved! Go to Solution.
Apple = countx(filter(Table, Table[Fruit]="Apple"), Table[Fruit])
Hope, this is what you need
@Jason2500 , Either you can create Measures or try two use multirow KPI
Hi @amitchandak Thanks for your quick reply. Can you please tell me how to create the measure using dax function?
Apple = countx(filter(Table, Table[Fruit]="Apple"), Table[Fruit])
Hope, this is what you need
what if I would count String in a column that contains a particular word
for example, a column contains the full name and I would calculate how many Jeff we have?
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |