Forum Discussion
How can get % using pre-calculated denominator
I have a member log by company and the total N per company is pre-calculated.
| Member Id | Program Attended | Company Total Employees (Denominator) | Company |
| 1 | Yes | 100 | A |
| 2 | No | 100 | A |
| 3 | Yes | 200 | B |
| 4 | No | 200 | B |
| 5 | No | 200 | B |
From this table, I want to calculate % of attendance per company. Like, Sum(attended member count)/Company Denominator.
How can I do this? I can't get the fixed pre-calculated denomination in the new measure calculation.
Esong2023 , this are parameters, and you can select numeric range under Parameter , than you can provide any numeric value into it that can be your company denominator
And for the formula you mentioned Sum(attended member count)/Company Denominator. In this instead of Company Denominator you can select parameter value which is higlighted in below snip
3 Replies
Esong2023 , this are parameters, and you can select numeric range under Parameter , than you can provide any numeric value into it that can be your company denominator
And for the formula you mentioned Sum(attended member count)/Company Denominator. In this instead of Company Denominator you can select parameter value which is higlighted in below snip
Hi Esong2023 , you can use parameters here and create dax using that dynamic parameter ,
So, you can select any value and your output will be automatically updated as per that,
You can find parameter under modelling tab,
Let me know in case any other help required,
And if this resolves your query please accept it as solution
Thanks for your response bhanu_gautam ! I am new to Power BI, not sure how to use DAX or what is DAX.
