Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago
Solved

Dax Error

Hi,

 

can someone please help me with the below error?

Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    vjnvinod

     

    Turn on the CROSS FILTERING between "INBOUND" and "COUNTRY" tables

     

    Actually filtering flows from one to many side table and not vice versa.....

    So when you select a region,, Inbound Table gets filtered but not the Country Table

     

    However you can turn it on

     

    This is how

     

     

9 Replies

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      8 years ago

      Zubair_Muhammad

       

      closing the bracket still doesn't helps, can you see, if you can help to rewrite this for me

       

      Table = SELECTCOLUMNS(Inbound,"Region", DISTINCT(Inbound[DeliveryRegion]),"Country",(Inbound[DeliveryCountry]))

       

      i tried to download your excel add in, but i don't find any link to download and can you help me to understand what does it has to do with Power BI.

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        vjnvinod

         

        If you simply want to get 2 columns,, you can use

         

        Table =
SELECTCOLUMNS (
    Inbound,
    "Region", Inbound[DeliveryRegion],
    "Country", Inbound[DeliveryCountry]
)

        If you want summarized results..you should use Summarize or SummarizeColumns

         

        Table =
SUMMARIZE ( Inbound, Inbound[DeliveryRegion], Inbound[DeliveryCountry] )
        Table =
SUMMARIZECOLUMNS ( Inbound[DeliveryRegion], Inbound[DeliveryCountry] )

         

        Let me know what you are trying to achieve

         

         

        You are right Excel Add-In has nothing to do with Power BI :smileytongue:

        Its just a signature promoting my product. Sorry for the confusion