Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |