Forum Discussion
Summarizing monthly data
Using the suggested posting, I was able to get this to work. Actual code is:
SUMX(CROSSJOIN(values('Reliability by Appllication (2)'[Appl_ID]),values('Reliability by Appllication (2)'[Reporting Month])),CALCULATE(SUM('Reliability by Appllication (2)'[Discovered Defects])))
I now get a monthly total of defects by application.
Thanks for the suggestion.
There seems to be a similar issue in this thread: https://community.powerbi.com/t5/Desktop/SUMMARIZE-error-The-expression-refers-to-multiple-columns-cannot/td-p/18456 Does that help?
Failing that, can you post the measure that is giving you grief, and an idea of how you want to use it in a visual - e.g. table/ matrix/ card, columns/rows you need ?
Cheers.
Using the suggested posting, I was able to get this to work. Actual code is:
SUMX(CROSSJOIN(values('Reliability by Appllication (2)'[Appl_ID]),values('Reliability by Appllication (2)'[Reporting Month])),CALCULATE(SUM('Reliability by Appllication (2)'[Discovered Defects])))
I now get a monthly total of defects by application.
Thanks for the suggestion.