Filter array by grouped fields.

[Syndicate_Admin]

Good morning.

I created this visualization in which its rows are Country of origin and country of destination.

As you can see if I expand for example Spain as a country of origin, the subtotals appear for each country of destination.

Now, create a filter with which to filter the countries of origin by their total, for this I created the following table:

Well, using "Volume" as a filter for that purpose works in my purpose, but the problem arises when I filter the page by dates, not having a relationship with them my filter produced by the new table does not have the expected functionality.

Could someone give me a solution? I hope I have explained myself clearly.

Thanks in advance.

[Syndicate_Admin]

I don't know how that works with my problem

[Syndicate_Admin]

@diegomerino Hello,
Can you try Related Dax to create a new column.

RELATED function (DAX) - DAX | Microsoft Learn


Thanks
Harish M

[Syndicate_Admin]

But having created the following table:

filtered tabla In =

CALCULATETABLE(

SUMMARIZE (

'Tabla In',

'Tabla In'[PAIS_ORIGEN],

"Volume", count('Tabla In'[Loading operation date])),

'Tabla In'[Type _base_transporte_2] = "Dedicated", 'Tabla In'[pvp_eur_km] < 10, 'Tabla In'[Customer amount] <> 0, 'Tabla In'[Supplier amount] <> 0, 'Tabla In'[Trip Type] = "International", 'Tabla In'[KM_CARGADOS] > 5)

I want to relate the new column "volume" to another table, but this function does not allow me to do it

[HarishKM]

Hello,
You can try USERELATIONSHIP dax. This will help you to create a virtual relationship between two table.

Kindly refer this USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Thanks
Harish M