Forum Discussion
Impactful IndividualIterator function with calculate
Applicable88 you need to understand context transition and row filter context. Calculate pass the date as row filter context and then calculate the count of mission for that date and then sumx adds all that up which doesn't happen when you are not using calculate.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Super UserApplicable88 you need to understand context transition and row filter context. Calculate pass the date as row filter context and then calculate the count of mission for that date and then sumx adds all that up which doesn't happen when you are not using calculate.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Impactful IndividualSeemingly I need to learn more about "context transisition". Since I put the count() and calculate(count()) into a table I got the same total. And calculate is not a iterator function per definition on the DaxGuide website. So I was confusing even more. As you can see I wallking in a circle for days also in another thread....