Forum Discussion

Bnb99's avatar
Bnb99
Frequent Visitor
8 years ago
Solved

Using the Correct DAX to count multiple rows as 1

I am very new to Power BI and DAX. I did a search to solve a problem with previous data using the Distinctcount code. it worked well in combining rows with the same value in the "record number colum"...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Bnb99 create a measure m1 = distinctcount(table1[recordnumber]) assuming record number is going to be unique accross all the injuries related to 1 persion in the visual level. in the chart visual filters or page level filter just select recordable = true

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Bnb99 create a measure m1 = distinctcount(table1[recordnumber]) assuming record number is going to be unique accross all the injuries related to 1 persion in the visual level. in the chart visual filters or page level filter just select recordable = true

Bnb99's avatar
Bnb99
Frequent Visitor
8 years ago

Thank you! This works!