Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PaulBRAULT
Regular Visitor

Column not synchronized with metrics (Dax Issues)

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.

 

bug synchronisation power bi.png

1 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()
)

View solution in original post

6 REPLIES 6
SpartaBI
Community Champion
Community Champion

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


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

@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.

@PaulBRAULT can you share the file?

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

@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

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()
)

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.