Forum Discussion
Temp table inside measure
Hi all, To explain my problem we want to create prediction for EOM conversion rate (CR), What my boss wants is basically CR based on (last 3 months by source * ("views /day this month by source...
Sorry, I didn't explain myself properly.
This helps me as well, but my main issue is
as seen on example, "Measure 7" is what I want to have as KPI, overall one.
But as this only aggregates tables, I have issue to get total value correct.
Instead of total leads*CR
I would like to see there 25.6+390.55+691.78+43.99 which is 1152,
Solved!
Seems like my problem was, that I was putting variables outside of SUMX iterator
as explained here https://community.powerbi.com/t5/Desktop/DAX-Using-variables-inside-iterators-such-as-SUMX/td-p/521044