Forum Discussion
litifeta
10 years agoAdvocate II
Help with a count function in DAX
Having trouble with something that is so simple in Excel I have a column of project names and blanks. I want a measure to calculate the unique text values so I can determine how many projects are...
Baskar
10 years agoResident Rockstar
Its cool in Power BI too.
1. Look the visual levell filter, from there u can choose advance filter, and pick "Is not Blank"
2. Change our measure to "Distinct Count"
let me know if i wont work.