Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a variable in a measure who returns a value only if I put a minus number at its end but nothing otherwise.
I use integer to identify years.
I want to report a trend, minus the year cicled in red.
The formula is the following to be sure to see the entire graphic:
m_CoutCapitauxPropres =
VAR varPrem =
CALCULATE(
MIN(tblEntrepriseDonnees[intAnnee]), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
)-1
RETURN
CALCULATE(
SUM(tblEntrepriseDonnees[sglCoutCapitauxPropres]),
FILTER(
CalendrierAnnuel,
CalendrierAnnuel[Année fiscale] > varPrem
), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
)
Should I simply replace -1 for nothing, zéro or +1, everything vanish.
m_CoutCapitauxPropres =
VAR varPrem =
CALCULATE(
MIN(tblEntrepriseDonnees[intAnnee]), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
) // Nothing is substracted or added to the evaluation
What's the logic behind that behavior? How to solve it? The best solution, for me would be to replace -1 for nothing.
Solved! Go to Solution.
Hello @Anonymous ,
Thanks for your help.
That formula returns effectively a value, which is the right value in its context, the year 2015. That's something I already verified in different ways.
In the RETURN part of my formula, should I change the variable varPrem for an integer (2015, for exemple) it works perfectly. It's like the variable varPrem doen't convey the value to the RETURN.
On the data side, the table looks like this. The year 2015 (the first of the graph) has no ratio calculated and when its the case, I try to get rid of it because that's meaningless. And I starting to believe it is the source of the problem but I don't know why.
intAnnee (year using integer) | sglCoutCapitauxPropres |
2015 | |
2016 | 0,04 |
2017 | 0,05 |
2018 | 0,00 |
2019 | 0,12 |
Hi @Pier2 ,
Could you please take this DAX out and create a measure to see whether it returns a null value?
CALCULATE(
MIN(tblEntrepriseDonnees[intAnnee]), USERELATIONSHIP(tblEntreprise[KEntreprise],
tblEntrepriseDonnees[FKEntreprise])
)
Best Regards,
Dino Tao
Hello @Anonymous ,
Thanks for your help.
That formula returns effectively a value, which is the right value in its context, the year 2015. That's something I already verified in different ways.
In the RETURN part of my formula, should I change the variable varPrem for an integer (2015, for exemple) it works perfectly. It's like the variable varPrem doen't convey the value to the RETURN.
On the data side, the table looks like this. The year 2015 (the first of the graph) has no ratio calculated and when its the case, I try to get rid of it because that's meaningless. And I starting to believe it is the source of the problem but I don't know why.
intAnnee (year using integer) | sglCoutCapitauxPropres |
2015 | |
2016 | 0,04 |
2017 | 0,05 |
2018 | 0,00 |
2019 | 0,12 |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |