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.
Hey guys I'm a new user on power bi and sometimes I have simple doubts that I can't solve my self.
I'll try be most clear as possible. I did this measure below expecting find only the percentage of growth for 2017 data.
But its gave me a result that i wasn't expecting on the circulated red:
I was expecting just the result with green underline.
Is there a way to apply my measure as a detail just at necessary part of my data?
Thanks in advance !!!
Solved! Go to Solution.
After contact @Greg_Deckler, he gaves me some help.
Indicating this sintaxy
Measure = VAR myyear = VALUES(Table6[Year]) RETURN IF(myyear = 2017, CALCULATE(AVERAGE(Table6[Value]),Table6[Year]=2017), BLANK())
That was the direction what I was needing!
Thx a loot @Greg_Deckler all credit for you!
=D
That was what I did and worked
Before>>> looking too ugly!
After >>> one hundred times better!
😄
After contact @Greg_Deckler, he gaves me some help.
Indicating this sintaxy
Measure = VAR myyear = VALUES(Table6[Year]) RETURN IF(myyear = 2017, CALCULATE(AVERAGE(Table6[Value]),Table6[Year]=2017), BLANK())
That was the direction what I was needing!
Thx a loot @Greg_Deckler all credit for you!
=D
That was what I did and worked
Before>>> looking too ugly!
After >>> one hundred times better!
😄
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |