Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Order #'s with multiple rows and products

Hello, I have a report that I need to be able to summarize the number of orders with and the percentage of orders that meet 2 conditions. The formula I used to assign values to orders that meet thes...
Need Help
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey Anonymous ,

    not sure if I understand you correctly, but maybe this is doing what you are looking for:

    Measure =
DIVIDE(
SUMX(
VALUES('<yourtablenema>'[ordernumber])
, calculate( average( '<yourtablenema>'[perfectoder] ) , '<yourtablenema>'[perfectoder] = 1 )
)
,[the distinctcountmeasure]
)

    Hopefully, this provides what you are looking for.

    If not, consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
3 years ago

Hey Anonymous ,

not sure if I understand you correctly, but maybe this is doing what you are looking for:

Measure =
DIVIDE(
SUMX(
VALUES('<yourtablenema>'[ordernumber])
, calculate( average( '<yourtablenema>'[perfectoder] ) , '<yourtablenema>'[perfectoder] = 1 )
)
,[the distinctcountmeasure]
)

Hopefully, this provides what you are looking for.

If not, consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the file to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That seems to have worked. Thank you Tom!