How to combine Distinctcount and relatedtable?

[Anonymous]

DA_FACT_DMS is a table name. And I have a column in this table named "Well_Name". How do I write a DAX to calculate count distinct of Well_Name? 

Note:- I'm creating this DAX in another table. That's why I'm doing it like this.

[Anonymous]

@Icey  what if I want to display all the well name? I don't want to count it. I've tried RELATED(DA_FACT_DMS[Well_Name])  but its not working 

Its the same case. I want to put the well_name column in another table. Both table are already connected.

[Icey]

Hi @Anonymous ,

Try this:

Column 2 =
CONCATENATEX ( RELATEDTABLE ( DA_FACT_DMS ), [Well_Name], ", " )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Icey · Accepted solution]

Hi @Anonymous ,

If the two tables are related, try this:

Column =
CALCULATE ( DISTINCTCOUNT ( DA_FACT_DMS[Well_Name] ) )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , what is other table and how they are related

distinctcount(DA_FACT_DMS[Well_Name])

or

countx(values(DA_FACT_DMS[Well_Name]),DA_FACT_DMS[Well_Name])