Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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!
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |