Forum Discussion

Lednum861's avatar
Lednum861
New Member
9 years ago
Solved

Count distinct text in different columns

Hi I'm very new to BI. I have my database setup similar to the table below. I want to use 2 tools in BI. One is a slicer and the other is a visual that counts and provides a total. I know how to use...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Lednum861

     

    Hi, try using this Dax:

     

    Measure =
COUNTROWS (
    DISTINCT (
        UNION (
            FILTER ( VALUES ( Table1[MFR1 Country] ), Table1[MFR1 Country] <> BLANK () ),
            FILTER ( VALUES ( Table1[MFR2 Country] ), Table1[MFR2 Country] <> BLANK () )
        )
    )
)
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Lednum861

 

Hi, try using this Dax:

 

Measure =
COUNTROWS (
    DISTINCT (
        UNION (
            FILTER ( VALUES ( Table1[MFR1 Country] ), Table1[MFR1 Country] <> BLANK () ),
            FILTER ( VALUES ( Table1[MFR2 Country] ), Table1[MFR2 Country] <> BLANK () )
        )
    )
)
Lednum861's avatar
Lednum861
New Member
9 years ago

Yes, this worked. Thank you so much. I actually tried your solution and the solution in the other post I received and both work perfectly. Thank you!