Need help with a measure

---

McCow wrote:

Shamatix,

try this and let me know pls if it work correct or no on yours data:

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]); 
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

---

Thanks a ton for the help, almost there:

https://i.imgur.com/FVnYWXK.png 

As you see on the above picture, it makes this one blank, eventho the momsgrundlag (vatamount)  is the same  

Fine Shamatix

It's so, as you really need:

---

McCow wrote:

Fine Shamatix

 

It's so, as you really need:

 

 

---

http://ge.tt/5XiQiln2

Take a look here.

For whatever reason it becomes blank eventho "Momsgrundlag" is the same for the same løbenummer

OK, Shamatix, you right, possible my mistake.

pls check this formula (based on previous):

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
//	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]);
	VARX.P('Indfortoldning';Indfortoldning[Moms grundlag]) = 0;
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

 MfG

---

McCow wrote:

OK, Shamatix, you right, possible my mistake.

pls check this formula (based on previous):

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
//	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]);
	VARX.P('Indfortoldning';Indfortoldning[Moms grundlag]) = 0;
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

 MfG

---

---

McCow wrote:

OK, Shamatix, you right, possible my mistake.

pls check this formula (based on previous):

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
//	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]);
	VARX.P('Indfortoldning';Indfortoldning[Moms grundlag]) = 0;
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

 MfG

---

Getting closer and closer:D

However this one turns up blank as well however here https://i.imgur.com/0XiOemi.png

it turns up blank as well (5 rows) same løbenummer and vatamount (moms grundlag)

here is an example 

http://ge.tt/3N1Fmln2

Dont know why that one becomes blank?

---

McCow wrote:

OK, Shamatix, you right, possible my mistake.

pls check this formula (based on previous):

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
//	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]);
	VARX.P('Indfortoldning';Indfortoldning[Moms grundlag]) = 0;
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

 MfG

---

I really cant seem to figure out why its working correctly on some and not on some of the others.