Forum Discussion

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost 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
Icon for Resolver III rankResolver III
8 years ago

Shamatix all of your data has different values. whats must happen, if strings (records) with same seriennummer (Løbenummer) contains different VAT-values (Momsgrundlag)? Must be blank? And if same SN and same VAT-value must be printed (calculated as average value)? Correct?

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost Partisan
8 years ago
McCow wrote:

Shamatix all of your data has different values. whats must happen, if strings (records) with same seriennummer (Løbenummer) contains different VAT-values (Momsgrundlag)? Must be blank? And if same SN and same VAT-value must be printed (calculated as average value)? Correct?

Exactly!:)

  • McCow's avatar
    McCow
    Icon for Resolver III rankResolver III
    8 years ago

    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
    • Shamatix's avatar
      Shamatix
      Icon for Post Partisan rankPost Partisan
      8 years ago
      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  

      • McCow's avatar
        McCow
        Icon for Resolver III rankResolver III
        8 years ago

        Fine Shamatix

         

        It's so, as you really need: