Forum Discussion

Esong2023's avatar
Esong2023
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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's avatar
bhanu_gautam
Super User
2 years ago

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's avatar
Esong2023
Frequent Visitor
2 years ago

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