Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

percentage

Hey Guys!   I have created a donut graph and the % doesn't display the correct numbers. Whenever I try to filter it via names the % isn't right, while the sum is correct! I want it to display as 46...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Because you do not provide data table, I create a table for test.

    1. below is my test table

    Table:

    2. create two measure with below dax formula

    Measure = SELECTEDVALUE('Table'[Lead Target])-SELECTEDVALUE('Table'[Lead Generated])
    Measure 2 = DIVIDE(SELECTEDVALUE('Table'[Lead Generated]),SELECTEDVALUE('Table'[Lead Target]))

    3. add a Donut chart and Card chart with measure and field

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Because you do not provide data table, I create a table for test.

1. below is my test table

Table:

2. create two measure with below dax formula

Measure = SELECTEDVALUE('Table'[Lead Target])-SELECTEDVALUE('Table'[Lead Generated])
Measure 2 = DIVIDE(SELECTEDVALUE('Table'[Lead Generated]),SELECTEDVALUE('Table'[Lead Target]))

3. add a Donut chart and Card chart with measure and field

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.