Group and Percent of Total

[FelipeDBA]

Hi, I need a help with something I thought would be easy.... In my column "Laboratorio" I have possible option and then I created two measure filtering each one, But I need this in the same measure...  and then have 200%... In Sql Server, I would do a query  grouping by "laboratorio" an then union with the other group. Does it make sense in power bi?

Thank you in advance!

[AlB]

Hi @FelipeDBA

Maybe if you show the code of your measure we can help. I do not exactly understand what you are trying to do.

A copy (sample) of your data model would also be very useful  

[FelipeDBA · Accepted solution]

hi @AlB! I did it! I was looking for a whey to get 100% for each value in "laboratorio" column, (2 in my case) To achieve this, I calculated two measeures with the % of total as:

totalIP = 
VAR IP = [AdesoesIP]
Var totalIP = CALCULATE([AdesoesIP];ALLSELECTED('Compare'))
return
DIVIDE([AdesoesIP];totalIP)

and then I just simple sum both measures

MeasureTeste = [totalIP]+[totalPf]

and worked!

Thank you!

[AlB]

Well done @FelipeDBA