Forum Discussion
Solved
How to create measure using a specific column value as the denominator
Hello, I'm still pretty new to Power BI and I'm having a ton of trouble understanding filter functions in DAX. Example: The above table is an example where I want to create a measure...
Hello,
Are you looking for something like this,
Note: Divide is the name of the sheet that I have
Please use this calculation to achieve the same
Solution 2 = SUM('Divide'[% of Total HH's]) / CALCULATE(MAX('Divide'[% of Total HH's]),ALL('Divide'),'Divide'[DEMOS]="Total Panel",'Divide'[PROD]=MAX('Divide'[PROD]))Regards,Ritesh,Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users
ribisht17
Super User
Super UserHello,
Are you looking for something like this,
Note: Divide is the name of the sheet that I have
Please use this calculation to achieve the same
Solution 2 = SUM('Divide'[% of Total HH's]) / CALCULATE(MAX('Divide'[% of Total HH's]),ALL('Divide'),'Divide'[DEMOS]="Total Panel",'Divide'[PROD]=MAX('Divide'[PROD]))
Regards,
Ritesh,
Mark my post as a solution if it helped you| Gentlemen & Ladies|Munde and Kudis| I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users
My You Tube Channel !! Connect on Linkedin || Power BI for Tableau Users
ribisht17 Yes, this is great, thanks so much!
