Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PradipMCT
Resolver II
Resolver II

Why percentage is different

Hi friends,

 

I have a table, shown below:

image.png

 

As you see the total percentage is 86.5, however, none of the quarters we have achieved above 65%. Why are these two figures showing different. 

 

the formula used to calculate percentage is as follows:

Adoption % = DIVIDE([Active mgmt CSOD Lrns], [Headcount],0)
 
The formula for Active mgmt CSOD Lrns is: 
Act Mgmt Csod Accessed = CALCULATE([Accessed CSOD],FILTER(csod, CSOD[Final Record Status]="Completed" && CSOD[User status]="Active" && CSOD[Type]="MGMT"))
 
The formula for Headcount is:
Headcount = COUNTROWS('WFA Report')
 
There are two tables here: 1 is CSOD and the other is WFA report table. There is 2 to many relationship between WFA and CSOD table. Here the WFA is the table of all the unique employees in an organisatoin. CSOD is the table where these employees have accessed any online course.
 
HOpe this much information is sufficient to help me. Unfortunately the data is confidential, so i cannot share it. 
1 REPLY 1
v-binbinyu-msft
Community Support
Community Support

Hi @PradipMCT ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_Binbin Yu

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.