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

    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!:)

    • McCow's avatar
      McCow
      Resolver III
      8 years ago

      Shamatix,

      try this and let me know pls if it work correct or no on yours data:

      MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]); 
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if
      • Shamatix's avatar
        Shamatix
        Post Partisan
        8 years ago
        McCow wrote:

        Shamatix,

        try this and let me know pls if it work correct or no on yours data:

        MomsGrundlag 2 = IF(CALCULATE(COUNTROWS('Indfortoldning');ALLEXCEPT('Indfortoldning';Indfortoldning[Løbenummer]))<2 || 
	AVERAGEX('Indfortoldning';Indfortoldning[Moms grundlag]) <> MEDIANX('Indfortoldning';Indfortoldning[Moms grundlag]); 
	AVERAGE(Indfortoldning[Moms grundlag]);
	BLANK()
)//if

        Thanks a ton for the help, almost there:

        https://i.imgur.com/FVnYWXK.png 

         

         

         

         

         

        As you see on the above picture, it makes this one blank, eventho the momsgrundlag (vatamount)  is the same