Forum Discussion
hstgeorge
Helper III
Helper IIIHelp Needed for Calculation
I have a data set that is set up so that one column contains one of the following: Gallons, Revenue, Fees, Discount and another column next to it that contains the value. I would like to divid...
Hi hstgeorge
Here's a sample PBIX with data and DAX Code
Try this measure
Ratio = DIVIDE( SUM('Table'[Amount]), CALCULATE( SUM('Table'[Amount]), FILTER(ALL('Table'), 'Table'[Type] = "GALLONS")))You should get this
Regards
Phil
PhilipTreacy
Super User
Super UserHi hstgeorge
Here's a sample PBIX with data and DAX Code
Try this measure
Ratio = DIVIDE( SUM('Table'[Amount]), CALCULATE( SUM('Table'[Amount]), FILTER(ALL('Table'), 'Table'[Type] = "GALLONS")))
You should get this
Regards
Phil