Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
8 years ago

Need help with a measure

Hello fellow users of Power Bi,   Well ill try to describe one of my issues:   =If(HASONEVALUE(Indfortoldning[Løbenummer]),AVERAGE(Indfortoldning[Moms grundlag]),SUMX(SUMMARIZE(Indfortoldning,Ind...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
McCow's avatar
McCow
Resolver III
8 years ago

Hi Shamatix,


my formula above is in principal correct. You must use Average or Don't summarize option for "New_Moms_grundlag", not Sum.

 

And the sum of all values (calculated in Excel) in this case is very near to QlikView: 2 864 629 678,17 .

 

I make the summarize measure (or change the formula for this column) a bit later.

 

Best regs

McCow's avatar
McCow
Resolver III
8 years ago

Shamatix
With this code the column "New_Moms_grundlag" can be summarized:

 

New_Moms_grundlag = 
IF(
            ABS([Rest])  < 1 ;
            CALCULATE(AVERAGEX(Indfortoldning;[Moms grundlag]);ALLEXCEPT(Indfortoldning;Indfortoldning[Løbenummer])) / Indfortoldning[Nr_Qty];
            BLANK()
)// if

And the construction of "Indfortoldning[Nr_Qty]" (Løbenummer-Quantity column) above can be changed with:

  

Nr_Qty = 
	CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))

 Here is the sample: