How can get % using pre-calculated denominator

[Esong2023]

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.  

[bhanu_gautam · Accepted solution]

@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

[bhanu_gautam]

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

[Esong2023]

Thanks for your response @bhanu_gautam ! I am new to Power BI, not sure how to use DAX or what is DAX.