Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi there ,
i need your a small help pls
i have a table which one name is "Table A" as below , i just would like to calculate on somwhere only "sales group " = C total somwhere , it should be a measure , could you pls say the formula to calculate pls
thanks in advance
Solved! Go to Solution.
Hi @erhan_79 ,
Try this measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @erhan_79
you don't need any coding, just put in table visuals Amount field and set aggregation
or create a supersimple statement like
SUM(Table[Amount])
or, for more complicated data models
CALCULATE(SUM(Table[Amount]), ALLEXCEPT(Table, Table[Sales Group]) )
Dear @az38
Thanks for your repy , used your formula as below
CALCULATE(SUM(Table[Amount]), ALLEXCEPT(Table, Table[Sales Group]) )
but when i use like that that measure is calculating based on all sales group , i just need Sales group C 's total because i need to use that totally in another visual
Hi @erhan_79 ,
Try this measure
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)