Dax Error

[vjnvinod]

Hi,

can someone please help me with the below error?

[Zubair_Muhammad · Accepted solution]

@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]

In the first DISTinct you didnt close the bracket ")"

[vjnvinod]

@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]

@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

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

[vjnvinod]

 @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.

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?

[vjnvinod]

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?

[Zubair_Muhammad · Accepted solution]

@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

[vjnvinod]

@Zubair_Muhammad

Zubair,  you are awesome, it resolved the issue.

any idea, why do i see dotted lines in on the pages across the border, it was post updation of power BI version.

[Zubair_Muhammad]

Hi @vjnvinod

I see them too

I dont know what they are for

[vjnvinod]

@Zubair_Muhammad

is there a way to get rid of it?

[Zubair_Muhammad · Accepted solution]

@vjnvinod

Try this

Set the transparenncy to zero as follows