Hello,
I'm facing issues when i try to make an IF statement in a measure, using measures.
I did some research myself but can't find the proper solution for my problem.
I created a table with project information. Using measures to calculate totals within columns. Next i want to create a measure with IF statement, that is using previous measures.
When i try to add the new measure it's showing extremely lots of rows that i don't want to see.
I think it's a common thing but i don't know the answer.
I've created this measure:
OHW op aanneemsom = IF(
Measure_Facturatie[Mijlpalen gefactureerd] >= Measure_OHW[Aanneemsom],
0,
IF(
Measure_Algemeen[Totaal realisatie] < Measure_OHW[Aanneemsom],
Measure_Algemeen[Totaal realisatie] - Measure_Facturatie[Mijlpalen gefactureerd],
IF(
Measure_Algemeen[Totaal realisatie] >= Measure_OHW[Aanneemsom],
Measure_OHW[Aanneemsom] - Measure_Facturatie[Mijlpalen gefactureerd],
0
)
)
)
Each measure i use, is also being used in my table. Values are calculated correctly.
And this is the table i created (each line, is a project):
After i add the new measure, this is the result:
I hope you can show my in the right direction.
Greetings,
Rolán
Solved! Go to Solution.
Hi @RvanMelis
try
OHW op aanneemsom =
IF (
NOT ISBLANK ( [Mijlpalen gefactureerd] )
&& NOT ISBLANK ( [Aanneemsom] ) && NOT ISBLANK ( [Totaal realisatie] ),
IF (
[Mijlpalen gefactureerd] >= [Aanneemsom],
0,
IF (
[Totaal realisatie] < [Aanneemsom],
[Totaal realisatie] - [Mijlpalen gefactureerd],
IF (
[Totaal realisatie] >= [Aanneemsom],
[Aanneemsom] - [Mijlpalen gefactureerd],
0
)
)
)
)
Hi @RvanMelis
try
OHW op aanneemsom =
IF (
NOT ISBLANK ( [Mijlpalen gefactureerd] )
&& NOT ISBLANK ( [Aanneemsom] ) && NOT ISBLANK ( [Totaal realisatie] ),
IF (
[Mijlpalen gefactureerd] >= [Aanneemsom],
0,
IF (
[Totaal realisatie] < [Aanneemsom],
[Totaal realisatie] - [Mijlpalen gefactureerd],
IF (
[Totaal realisatie] >= [Aanneemsom],
[Aanneemsom] - [Mijlpalen gefactureerd],
0
)
)
)
)
Hi Tamerj, this works perfectly! Thank you very much.
Can you please explain to me what i did wrong or why your measure works? I'm trying to understand so i can take this into next things.
The first if statement: if the two measures are blank they are equal and the if statement forces 0 therefore all the previously hidden rows will appear to disply the value 0
the new code checks first if they are not blank then continues with other conditions otherwise returns blank
User | Count |
---|---|
77 | |
38 | |
33 | |
15 | |
12 |
User | Count |
---|---|
86 | |
31 | |
26 | |
18 | |
13 |