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.



Irwan's avatar
Irwan
Super User
1 year ago

hello ponchibonos 

 

here is the result using exact same DAX as previous one.

Value Sought =
var _Sum1 = SUM('Table'[Percentage result])
var _Sum2 =
CALCULATE(
    SUM('Table'[Percentage of each Question]),
    FILTER(
        'Table',
        not ISBLANK('Table'[Percentage result])
    )
)
Return
DIVIDE(
    _Sum1,
    _Sum2
)
 

6a. no filter

6b. Form 1 filter

6c. Question 1 filter

 

i am not sure what is the difference from previous post, but let us know what is your expected/desired goal.

 

Hope this will help.

Thank you.