Forum Discussion
Helper IIIrollup total scalar error
Hello
Rollup Dax Code works fine in daxstudio, getting measure column syntax error in power bi for same expression.
EVALUATE
var a1 = CALCULATETABLE( SUMMARIZE( 'Location' , ROLLUP( 'Location'[System] ) , "SysTotal", [Total1] ) , TREATAS( {"System" } , 'SAP Location'[System] ) )
Var a2 = CALCULATETABLE( SUMMARIZE( 'Location' , ROLLUP( 'Location'[REGION]) , "SysTotall", [Total1] ) , TREATAS( {"NORTH", "SOUTH" } , 'Location'[REGION]) )
RETURN union (a1 , a2)
refint650 you can return multiple rows in Power BI, the measure has to return a scalar value, if you create a calculated table in Power BI desktop then it will work.
✨ Follow us on LinkedIn
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.⚡
4 Replies
- parry2k
Super User
refint650 you can return multiple rows in Power BI, the measure has to return a scalar value, if you create a calculated table in Power BI desktop then it will work.
✨ Follow us on LinkedIn
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.⚡
refint650Hi
I wanna calculate totals by date, region , city. created custom table with date, region, location columns, on top of it should i create measure columns with above expression or how should i achieve functionality
ref