Get the average percent from 2 different columns

[Anonymous]

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:

[V-lianl-msft]

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]

Hello

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

[V-lianl-msft]

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.

[Anonymous]

ok.. But can I someshow combine these 2 columns and make each of them still contain their individuell values?

[Anonymous]

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

[amitchandak]

@Anonymous ,

I think you need sum of Averages

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

Appreciate your Kudos.

[Anonymous]

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] )
)

[Greg_Deckler]

It sounds like you want a multi-column aggregation:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...