Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Why wont the same formula work?

Hello,   I have a table I created called countries, it is a simple formula.   Countries = Distinct('Transactions'[COUNTRY])   This works perfect--No issues and yes there are multiple AND duplic...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    You could do it in Power Query with something like this:

    let
    Source = Transactions,
    KeptOnlyCountryAndRegion = Table.SelectColumns(Source,{"Country", "Region"}),
    RemovedBlankCountries = Table.SelectRows(KeptOnlyCountryAndRegion, each [Country] <> ""),
    RemovedDuplicateCountryandRegions = Table.Distinct(RemovedBlankCountries)
in
    RemovedDuplicateCountryandRegions

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Your "Country Formula" is a Table, and the "Region Formula" is a measure.

Try change your "Distinct Countries Table Formula" to this:

 

Countries = Distinct( SELECTCOLUMNS(Transactions;"Country Slicer";[Country];"Region Slicer";[Region]) )

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Oops, yeah that's a measure not a column. I mixed up the icons in my head. Still, either way it's not a table.