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

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.

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

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

      • McCow's avatar
        McCow
        Resolver III
        8 years ago

        Hi Shamatix

         

        please, check THIS solution.

        I added two calculated columns. It is old school, but i suggest, that it is right solution.

        You must use "New_Moms_grundlag" column. And "Rest" is another technical column (for test), must be leaved, The Nr_Qty and VarX - not obligated and can be erased.