What to do with the following DAX IN THE MATRIX TABLE?

[Anonymous]

How can I fix this in order to get what is needed?

Anyhelp would be so much apprevciate.

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

[dax]

Hi chromo4130,

In your scenario, it seems that you want Table 1 and Table 2 have same rows, right? But I check your sample data, I find that in PBI Data, there is no corresponding [MATRICULA]  records, when you choose [IDJefe], so it will lose some rows. This is default, you don't have record in dataset, it won't show it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @dax  you are right about what you said...the problem is that Im not explaining my self right.

The logic of the ID JEFE is what is shown in the picture below:

Please take a look in the NEW sample DATA where I explain better the situation:

so greatful for your help!!!

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

[dax]

Hi chromo4130,

You need to know if there is no record in datset, you can't see this in column field or row field in visual, you need to create measure to show it. But in your sample, you use these in column or row field, so you could not view it. This is by design. You could check your sample

If you want to show this, I think you could left join these two table to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.