Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I tried using
NewMeasure = CALCULATE(COUNT(TableName[ColumnName]) , (TableName[ColumnName])="Insert Word Here")
Yet for some reason it doesn't register the table name/column name after the commma. Would appreciate any input.
@Anonymous ,
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
@Anonymous,
What's the specific error message? You may also modify your measure using DAX below:
NewMeasure = CALCULATE ( COUNT ( TableName[ColumnName] ), FILTER ( TableName, TableName[ColumnName] = "Insert Word Here" ) )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried COUNTX ?
It should look something like: NewMeasure = COUNTX(TableName , [ColumnName]="Insert Word Here")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |