Forum Discussion

fbostan1's avatar
fbostan1
Helper I
3 years ago

Measurement

I have this three tables.  The (% of Total Lives) table is not showing the correct percentage when I write a measurement to divide the numbers in (Submitted Lives Count) to the Total from (Submitted...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi fbostan1 ,

 

It sounds like you are trying to calculate the percentage of total lives in Power BI. There are different ways to do this, depending on the context and the data model you have. One possible solution is to use the Show value as option in the table visual and select Percent of grand total. Another possible solution is to create a measure using the DIVIDE function and the ALL function to ignore any filters on the table. For example:

Percent of Total Lives = DIVIDE(COUNTA('underwriting - powerterm (ni)'[policy_num]), CALCULATE(COUNTA('underwriting - powerterm (ni)'[policy_num]), ALL('underwriting - powerterm (ni)')))

If you still have doubts, please let me know the answers to the questions below.

Your three tables are three matrices, right?

What's your raw data?

And I think your [Total] is a measure, how is the measure written?

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

fbostan1's avatar
fbostan1
Helper I
2 years ago

The problem I have in my measure is that table (% of Total Lives) is adding all the numbers from table (Submitted Lives Count) instead of just taking 17,759 divide by 376,861. 

PowerTerm total and PrecisionTerm Total are two seperate table and they don't have any relationship.