Forum Discussion

equevedo84's avatar
equevedo84
Frequent Visitor
2 years ago
Solved

Create Measure/Calculated Column Dividing Two Sums

Good afternoon,   I'm trying to create either a calculated column or measure (whichever works best) to replicate an operation from an Excel report into Power BI.  There is a column for Measures and...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks kpost 
    Hi, equevedo84 

    Based on the data you provided, I used the following DAX expression:

    Division = 
VAR _compliant_members = SUM('Table'[Compliant Members])
VAR _Eligible_members = SUM('Table'[Eligible Members])
RETURN DIVIDE(_compliant_members,_Eligible_members)

    Here are the results:

    I've uploaded the PBIX file I used this time below.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks kpost 
Hi, equevedo84 

Based on the data you provided, I used the following DAX expression:

Division = 
VAR _compliant_members = SUM('Table'[Compliant Members])
VAR _Eligible_members = SUM('Table'[Eligible Members])
RETURN DIVIDE(_compliant_members,_Eligible_members)

Here are the results:

I've uploaded the PBIX file I used this time below.

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.