Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hell Everyone,
Below is the snapshot of my report;
I have filtered these data's based on Payment received date which is month of June and Parent Account is ABC. In this case after applying filters the total of Weight is 37494623.17.
Thankyou @az38 and @amitchandak , but this measure doesn't work.
For reference I had given a single table.
But I have two different tables, Table- Account which has account id and Table- Recievables which has payment recieved date based on which we need to apply filter for the data. For a given account and for a given payment recieved date weightage to be calculated which is indiviadual weight divided by overall weight for the given account and payment recieved month and year.For eg., if no filter is applied the table appears as given below
Now, for the 1st parrent account(lets name it xyz) the payment recieved date is 7/25/2019. And lets say for xyz for the month of July(07) and year 2019 the total weight is 5000000, then my measure needs to be like 1357986.6/5000000.
I hope I am not confusing, please let me know if you want me to explain any further