Forum Discussion

ponchibonos's avatar
ponchibonos
Helper I
1 year ago
Solved

Percentages without null values and Dates

Hello Irwan  and colleagues. Some weeks ago I made this post https://community.fabric.microsoft.com/t5/Desktop/Percentages-without-null-values/m-p/4732647#M1412266 about the procedure to calculate P...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello ponchibonos,
    Thanks for sharing those examples.

    I have reproduced your scenario in Power BI Desktop and confirmed that the output matches your expected results:

     

    For your reference, I’m attaching the .pbix file containing the working example so you can review the setup and DAX logic in detail.

     

    Best Regards,
    Ganesh singamshetty.



v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

Hello ponchibonos,
Thanks for sharing those examples.

I have reproduced your scenario in Power BI Desktop and confirmed that the output matches your expected results:

 

For your reference, I’m attaching the .pbix file containing the working example so you can review the setup and DAX logic in detail.

 

Best Regards,
Ganesh singamshetty.



ponchibonos's avatar
ponchibonos
Helper I
1 year ago

Thanks again for this new version. 

The DAX has a detail that I have not been able to identify that makes the calculation inaccurate.

When filtering for the year 2025. The result should be:
Sum of percentage result = 90
Divided by the total excluding null values = 170

For a result of 52.94%

 

With the latest version you sent me, the result is 54.17%

 

 

 

 

The DAX works fine with the Person 1, Person 2 filter.

Could you help me find the error?

 

I left the pbix with the four versions of DAX 

 

https://drive.google.com/file/d/1hMxu2FzfSDYhR_24DVIEXL4tobxbEIua/view?usp=sharing

 

 

Thanks again.