Column not synchronized with metrics (Dax Issues)

[PaulBRAULT]

Hello to all,

Thank you in advance for your help.

My problem is on Power BI Desktop and when my report is opened, my RAM is used at 85% which could be the origin of the problem I am going to describe to you.

When I make a column in a table. The values of the column are not synchronized with the value of the measure. As you can see on the screenshot. The value of the measure is "7". But the table column returns "2" (2 is the old value when the file was less complex).

I have never encountered this problem before and it is very surprising, thank you very much for your help.

[SpartaBI]

@PaulBRAULT maybe try to clear the cache in the settings or delete the visual and put it again.

      

Showcase Report – Contoso By SpartaBI

[PaulBRAULT]

@SpartaBI Hello, thank for you quick answer.

i've try again to clear alls caches and also try with differents visuals but its doesn't working when i use column.

[SpartaBI]

@PaulBRAULT can you share the file?

[PaulBRAULT]

@SpartaBI  Here you can find the files "old link"

[SpartaBI]

@PaulBRAULT I think you have a dax issue and not a cache issue 🙂
It's kind hard to explain cause I'm not sure what you meant to do but it's ok the result are different in the way you created them.
You can send me a link to zoom / teams and I'll try to help

[SpartaBI · Accepted solution]

The what if parameter needed to be used in a measure and not in a column:?

Quantité intiale Measure = SWITCH(
    SELECTEDVALUE(Livraison[Composant]),
    "Rail omega ml",[* Rail omega ml],
    "Rail inter ml",[* Rail inter ml],
    "Serreur ml",[* Serreur ml],
    "Habillage ml",[* Habillage ml],
    "Traverse ml",[* Traverse ml],
    "Vis panne u",[* Vis u],
    "Boulon u",[* Boulon u],
    "Griff u",[* Griff u],
    "Crapaud cadre u",[* Crapaud RT u],
    "Eclisse STR u",[* Eclisse STR u],
    "Tuile omega u",[* Tuile omega u],
    "Tuile inter u",[* Tuile inter u],
    "Eclisse vis u",[* Eclisse vis u],
    "Butee basse u",[* Butée basse u],
    BLANK()
)