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

  • McCow's avatar
    McCow
    Icon for Resolver III rankResolver 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.

     

    • Shamatix's avatar
      Shamatix
      Icon for Post Partisan rankPost Partisan
      8 years ago

      This looks promising, however I found quite a lot of mistakes =/ 

      As you can see on the below picture this is one of many where it does not take the average 

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

        I look for better workaround solution and in this case i need all ther rows in your example set. It is possible to add?  I feel we are closer and closer