Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get the average percent from 2 different columns

Hello!

 

So I got these columns with this formula that I would like to combine to get the average percent of the stuff thats "Avklarat".

 

2tim = IF('logg'[Time]>1/24/60*120;"Missat";"Avklarat")

 

1tim = IF('Logg'[Time]>1/24/60*60;"Missat";"Avklarat")

 

These columns make these donut charts and I want another donut chart that shows the aveage percent of Avklarat in the picture below:

 

Need Help

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello!

       

      Sorry, but i'm new to this and I dont really get it. I tried this but it wont work:

       

      New Table = 
SUMMARIZE (
    'Logg';
    'Logg'[2tim];
    'Logg'[1tim];
    "Average percent"; MAX ( 'Logg'[Average percent] )
)

       

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    It is very difficult to analyze without looking at the data and just by imagining. See if you can share a PBIX file with dummy data.(using OneDrive for Business)

     

    Best Regards,
    Liang
    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
      6 years ago

      I'm sorry but I have no idea how to give you a dummy without sharing sensitive information...

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello

       

      I sent you a dummy with a google drive link in PM

       

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        Sorry, I can't get more information from your dummy data.
        If 1Tim and 2Tim are in the same table, why their total rows are not equal?

         

        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.