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

 

I'm not 100% sure if i rght undestand your request, but my answer is so:

 

MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2;AVERAGE(Indfortoldning[Moms grundlag]);BLANK())

It's work like this, as you write (or I as understand :)

 

 

Best regs

  • Shamatix's avatar
    Shamatix
    Post Partisan
    8 years ago
    McCow wrote:

    Hi Shamatix

     

    I'm not 100% sure if i rght undestand your request, but my answer is so:

     

    MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2;AVERAGE(Indfortoldning[Moms grundlag]);BLANK())

    It's work like this, as you write (or I as understand :)

     

     

    Best regs

    Ill try it out, thanks a lot :)

  • Shamatix's avatar
    Shamatix
    Post Partisan
    8 years ago

    I found a mistake you make ALL "Moms grundlag" blank if there is mulitple lines, I only want it blank if there is multiple lines and some of em has different momsgrundlag values so they are different from eachother, I hope that makes sense.

    For example the above scenario can happen, and then I want it to be correct since ALL "Momsgrundlag" is the same number

     

    Any way to get the total at the bottom as well?

    • McCow's avatar
      McCow
      Resolver III
      8 years ago

      A simplest way without complicate calculation is separate measure + Card visualisation. Totals in the table must be OFF.

      • Shamatix's avatar
        Shamatix
        Post Partisan
        8 years ago
        McCow wrote:

        A simplest way without complicate calculation is separate measure + Card visualisation. Totals in the table must be OFF.

        What do you mean by the above, also I added a screenshot to my previous comment^^