Dax Formula - Getting Count with multi tables(not related)

[Chandrashekar]

Hello Team,

Can you guide me with Dax formula to get count where one table(not established relationship_. Formula should consider slicer(Date) and change value accordingly.

1. Source and Grade table - have established relation

2. Date table - not established relation with any table.

Regards,

Chandrashekar B

[smpa01 · Accepted solution]

@Chandrashekar  it is certainly possible

_countrows = 
VAR _name =
    MAX ( Table3[Name] )
VAR _location =
    MAX ( Table3[Location] )
VAR _tbl =
    CROSSJOIN (
        SELECTCOLUMNS ( { _name }, "name", [Value] ),
        SELECTCOLUMNS ( { _location }, "location", [Value] )
    )
RETURN
    CALCULATE (
        COUNTROWS ( Table1 ),
        TREATAS ( _tbl, Table1[Name], Table1[Location] )
    )

[Chandrashekar]

Hello,

It is working perfectly and can you let me know if I can order Location for ex(1. My and 2. BL).

Regards,

Chandrashekar B

[smpa01]

@Chandrashekar  yes you can by clicking on the location 

[Chandrashekar]

Hello,

I used sorting column but am unable to hide the sorting column. is there any way we can hide it.

Regards,

Chandrashekar B

[ValtteriN]

Hi,

You could create a passive realtionship between the tables and use USERELATIONSHIP. Another option would be to include the [Date] in your calculate. I would need more information on your issue to create an example.

[Chandrashekar]

Hello,

Can you please share one example formula for passive relation ship and dax formula for below example

Table 1 field: Company and Region

Table 2 field: Company and Region (Company unique)

Table 3: Date should consider from slicer.

Regards,

Chandrashekar B

[Chandrashekar]

Hello,

Can you please share one example formula for passive relation ship and dax formula for below example

Table 1 field: Company and Region

Table 2 field: Company and Region (Company unique)

Table 3: Date should consider from slicer.

Updated formula(Changed date):

Regards,

[Chandrashekar]

Hello,

Can you please share one example formula for passive relation ship and dax formula for below example

Table 1 field: Company and Region

Table 2 field: Company and Region (Company unique)

Table 3: Date should consider from slicer.

Updated formula(Changed date):

Regards,

[Chandrashekar]

Hello Valterri,

I have shared pbix file.  PBIX Report 

Could you share dax formula. When I change date in slicer Table should get update accordingly. 

Regards,

Chandrashekar B

Regards,