Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Avivek
Post Partisan
Post Partisan

Help needed with the DAx measure

Hell Everyone,

Below is the snapshot of my report;

  1. Avivek_0-1597059607781.png

     

    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.
    I want another measure which calculates the (individual weight /overall weight based on account and payment received date), eg.
    (715441.52 / 37494623.17), (4207785.33/37494623.17) and so on for every column.
    I tried creating few measures but never ever close to the value.
    Appreciate your response on this.

3 REPLIES 3
amitchandak
Super User
Super User

@Avivek , Try like

divide(sum(Table[weight]),calculate(sum(Table[weight]),allselected(Table)))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
az38
Community Champion
Community Champion

@Avivek 

it may look like

Measure = 
DIVIDE(
SUM('Table'[Weight]),
CALCULATE(SUM('Table'[Weight]), ALL(Table))
)

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

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

Avivek_1-1597064754886.png

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

 

 

 

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors