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
Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost 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
Icon for Resolver III rankResolver 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
    Icon for Post Partisan rankPost 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
      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!:)

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

    • McCow's avatar
      McCow
      Icon for Resolver III rankResolver III
      8 years ago
      Shamatix wrote:
      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

      No, no, as Card visualization must be used ANOTHER measure (ex. MomsGrundlag) not MomsGrundlag2.  Or Total of column.

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

        No, no, as Card visualization must be used ANOTHER measure (ex. MomsGrundlag) not MomsGrundlag2.  Or Total of column.

         

        But the normal "MomsGrundlag" doesnt show the correct result? as it still calculates the fields that is supposed to be blank but arent?