Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 these conditions is
Solved! Go to Solution.
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
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
That seems to have worked. Thank you Tom!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |