Forum Discussion

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

Trouble with a measure

Hello fellow users of Power Bi,   Well ill try to describe one of my issues: I am making a table with a ton of invoice data and of course some of the invoices has multiple lineitems which can be s...
General Comment
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

I am still not clear with your requirement but try this measure

 

=If(HASONEVALUE(Indfortoldning[Løbenummer]),if(DISTINCTCOUNT(Indfortoldning[Moms grundlag])>1,BLANK(),AVERAGE(Indfortoldning[Moms grundlag])),SUMX(SUMMARIZE(Indfortoldning,Indfortoldning[Løbenummer],"ABCD",if(DISTINCTCOUNT(Indfortoldning[Moms grundlag])>1,BLANK(),AVERAGE(Indfortoldning[Moms grundlag]))),[ABCD]))

 

Hope this helps.

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost Partisan
8 years ago
Ashish_Mathur wrote:

Hi,

 

I am still not clear with your requirement but try this measure

 

=If(HASONEVALUE(Indfortoldning[Løbenummer]),if(DISTINCTCOUNT(Indfortoldning[Moms grundlag])>1,BLANK(),AVERAGE(Indfortoldning[Moms grundlag])),SUMX(SUMMARIZE(Indfortoldning,Indfortoldning[Løbenummer],"ABCD",if(DISTINCTCOUNT(Indfortoldning[Moms grundlag])>1,BLANK(),AVERAGE(Indfortoldning[Moms grundlag]))),[ABCD]))

 

Hope this helps.

 

https://community.powerbi.com/t5/Desktop/Need-help-with-a-measure/m-p/326065#M145459 

I made a new thread, however I am really struggling converting my Qlikview to a 1:1 Power Bi, would love to get you on skype and be able to show you^^

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Does my suggested formula work?