The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to 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()
)
@PaulBRAULT maybe try to clear the cache in the settings or delete the visual and put it again.
@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 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()
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |