Conception problem

[KarimBernard01]

Hi everyone,

I have a problem with a Power BI file, which seems to have a conception mistake.

You will find below the model, and the way we would like to show informations.

Goal : have a "Dispo à la vente" by campaign and specie

In Power BI, we have these cards, which are OK, without context.

Below, calculation is : A + B + C -D - E = Dispo à la vente

But the problem is that when I want to filter on a campaign, or a specie, my matrix goes wrong.

Some columns are then empy (link pb ??)

I suspect problems with links between tables, but I don't know how to solve them.

You will find below my model.

In red, dimensions, in green, measures used.

I hope you will have enough informations with it.

Thank you very much for your help !

Best regards,

Karim

[MFelix · Accepted solution]

Hi @KarimBernard01 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.