cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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 Lives by Product) table.

this is the measurement I have for the Total Lives Table (

DIVIDE(COUNTA('Underwriting - PowerTerm (NI)'[POLICY_NUM]), [Total])

I don't know where those percentage come from.

2 REPLIES 2
Community Support

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.

Frequent Visitor

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors