Forum Discussion
Getting one extra count.
Hello All,
I have a measure as
10 Replies
Hi sdhn
Try this:
OpenNMSCounts = Distinct(ALLSELECTED(Source))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Did not work out. Error
screen grayed out
Getting error:
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Hi sdhn
Try to add a column from your table to the formula:
OpenNMSCounts = Distinct(ALLSELECTED(Source[Column]))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/It was my mistake. I rephrase my question.
I have merged multiple files onto one file during transformation & load. New file is called Source.Source. Name column has all files name. This column has created by load process.Below measure is counting one extra row. I want exact rows.we are using following measure to get total counts of each types or files.
Source = CALCULATE(COUNT(Source[Source.Name]), ALLEXCEPT(Source,Source[Source.Name]))
