The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have a formula that multiplies two columns. I use it in a table visual, but dont get the expeted value (I want the sum of the meassure, but I get the multiplication of the sums of the columns):
I added a hardcoded column with the sames values to show the expected value.
Thanks in advance!
Read my article here. Take not of the section "totals don't add up" towards the end of the article.
https://exceleratorbi.com.au/use-sum-vs-sumx/
Thanks! That worked! (it is a bit slower, but nothing to worry)