Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Calculate group sum whn you have 2 or more categories
Final output: Group sum is calculated based on categories
Process:
1. Upload data > transform data > Add column > Index Column > From 1
you will see index colum in your data, save and close
2. Load data into "Data" colum in power BI,
From "Fileds" > Add "New Column > use Dax code mentioned below
Hi @Reddyp
Thank you for sharing your solution and experience with the community!
Best Regards,
Community Support Team _ Jing