Forum Discussion

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
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.

PErcentage and dates (Final).pbix30 KB

ponchibonos

Helper I

1 year ago

Hello, colleagues. Apologies for not responding sooner; I was ill and unable to do so.
Thank you for all your responses. I believe my explanation of what I need was unclear.

I already have the DAX that calculates the percentages without evaluating the null values. What I need is a measure, in addition to the previous calculation, to only calculate the most recent response when there are two responses from the same person. In the example from my model, Person 1 responded in 2024 and 2025, so I need the measure to only calculate for the year 2025 for the Person 1.