DAX USED IN MATRIX NEED TO SHOW OTHER DIMENSIONS IF IT CERO

[Anonymous]

Help with a DAX

In my Data I have 2 tables, where we have People ID and in the other table, ammounts. The desired result is to see the whole team (every people ID) even if the have NO DATA but With my DAX I only can see the People ID who have data.

IM gonna leave a data PBIX sample where you guys see  the actual result in the matrix table with my DAX (Table nuumber 1) and a second table where Im trying to show the effect I need. (Showing everybody)

The data is filtered by a 3th table "the bosses"

SAMPLE DATA:

https://www.dropbox.com/s/dii58k7m2zb618f/BI%20VISITAS%20DEMO%20forum.pbix?dl=0

Tknks in advance for any HELP.

Thanks in advance:

[Anonymous]

Hi there -

I think because you have a one to many relationship between the tables "dotacion (2)" and "PBI" this is happening. If you want to display all data, then change the following:

> Go the relationships tab and edit the relationship to make the value of "Cross filter direction" to "Both" from "Single".

Once done, please check and let me know if you that helped you?

Regards

[Anonymous]

Hi @eppapu... I tried that and anything, could you take a look AT the example please?