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

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^^

      • McCow's avatar
        McCow
        Resolver 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
      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.

      I tried to use the Card visualization with yoru measure but it turns out blank

      • Shamatix's avatar
        Shamatix
        Post Partisan
        8 years ago

        Hey McCow,

         

        I have uploaded some sample data on the link below so you can see it still makes certain invoices blank, eventho the "Moms Grundlag" is the same amount for each line, so it should just show the avarage in this case.

         

        http://ge.tt/4HRrAmn2