Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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

     

     

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    vjnvinod

     

    Try this

    Set the transparenncy to zero as follows

     

     

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago
In the first DISTinct you didnt close the bracket ")"
  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful 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
      Icon for Community Champion rankCommunity 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

       

      • vjnvinod's avatar
        vjnvinod
        Icon for Impactful Individual rankImpactful Individual
        8 years ago

         Zubair_Muhammad

         

        thanks, but how do i download the add in, i find it intresting.

        my actual challenge is below, if you could resolove this, you are my savior.

         

        Relationshipsetupnew.JPG

        I have 2 middle table Region and Country, which i have used it as dropdown in my dashboard and the relationship is setup something like above

        Now what happns is whn i go to the dashboard, and select a region from the dropdown, lets say CESA, it doesn't shows me the countries related to that particular region, rather it shows me all the countries listed

         

        how do i fix this? or sync both region and country slicer?

         

        CESA region.JPG