Forum Discussion

Parvez933's avatar
Parvez933
Helper I
4 years ago

sumx()

Hi,   RetailerInvoice = VAR bucket_min = CALCULATE(MIN('PCT-voice'[min])) VAR bucket_max = CALCULATE(MAX('PCT-voice'[max])) VAR total_printers = CALCULATE(DISTINCTCOUNT(Reatil[uniquekey])) re...
Need Help
Parvez933's avatar
Parvez933
Helper I
4 years ago

I am unable to upload pbix or excel here, can you please help

  • OliT's avatar
    OliT
    Resolver I
    4 years ago

    Hi Parvez933 

    It is not possible to infer what kind of results you need to calculate only by the wrong measure above, so I need some sample data and your expected result to write the measure, you can share some screenshots or share data in text format here. 

    Besides, the syntax for sumx is  SUMX(<table>, <expression>).

    Usually we can write it like this, sumx(filter(table,table[column]<max&&table[column]>min),<expression>)

     

    Regards,

    OliT

    • Parvez933's avatar
      Parvez933
      Helper I
      3 years ago

      Hi Microsoft PowerBI Team,

       

      I have been awaiting your help in resolving the attachments issue, the topic is unresolved and experts are asking me to share some sample data which I am unable to share via any form of document.

       

      Request your help in sharing the attachments and resolve this topic asap.