Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Solved! Go to Solution.
Hi @Marcel_Graumans ,
Try expression below:
Measure = IF(MAX('Table'[Begroting])=BLANK()&&MAX('Table'[Meerwerk])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting])+MAX('Table'[Meerwerk]))
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Marcel_Graumans ,
I made simple samples and you can check the results below:
Column =
VAR _VIRTUAL = ADDCOLUMNS('Table (2)',"C1_1",IF('Table (2)'[C1] = BLANK(),0,1),"C2_1",IF('Table (2)'[C2] = BLANK(),0,1),"C3_1",IF('Table (2)'[C3] = BLANK(),0,1))
VAR _INDEX = 'Table (2)'[Index]
RETURN
SUMX(FILTER(_VIRTUAL,[Index] =_INDEX && [C1_1]+ [C2_1] + [C3_1] = 1),[C1]+[C2]+[C3])
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
thats not what i mean i have a import and now i want to adit a column
if begroting and meerwerk is filled then adit in column new if not then budget in new column
Budget | Begroting | Meerwerk | New |
€ 260.000,00 | € 260.000,00 | ||
€ 260.000,00 | € 260.000,00 | ||
€ 260.000,00 | € 260.000,00 | ||
€ 6.500,00 | € 6.253,32 | € 6.253,32 | |
€ 16.500,00 | € 7.797,14 | € 7.797,14 | |
€ 6.500,00 | € 6.253,32 | € 6.253,32 | |
€ 7.500,00 | € 7.302,52 | € 7.302,52 | |
€ 3.500,00 | € 5.838,58 | € 5.838,58 | |
€ 1.760,00 | € 1.461,93 | € 1.461,93 | |
€ 5.000,00 | € 6.682,68 | € 6.682,68 | |
€ 7.500,00 | € 8.840,81 | € 8.840,81 | |
€ 2.000,00 | € 2.648,40 | € 2.648,40 | |
€ 0,10 | € 0,00 | € 0,00 | |
€ 7.500,00 | € 5.451,49 | € 5.451,49 | |
€ 1.700,00 | € 1.696,50 | € 1.696,50 | |
€ 3.500,00 | € 3.489,51 | 883,74 | € 4.373,25 |
€ 4.500,00 | € 4.500,00 | ||
€ 2.500,00 | € 2.500,00 | ||
€ 0,10 | € 0,10 | ||
€ 2.500,00 | € 2.500,00 | ||
€ 2.500,00 | € 2.500,00 | ||
€ 3.500,00 | € 3.500,00 | ||
€ 3.500,00 | € 3.500,00 |
Hi @Marcel_Graumans ,
You can refer to the following results:
Measure = IF(MAX('Table'[Begroting])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting]))
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Marcel_Graumans ,
Try expression below:
Measure = IF(MAX('Table'[Begroting])=BLANK()&&MAX('Table'[Meerwerk])=BLANK(),MAX('Table'[Budget]),MAX('Table'[Begroting])+MAX('Table'[Meerwerk]))
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
nope i get this result sorry its in dutch
i fix it works now
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
58 | |
19 | |
12 | |
11 | |
10 |