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 guys, I need some help to solve this problem. I want that the variable MaxRank returns the maximun value of variable rankeamento1.
How could i do that? I've tried many ways to put the right result but with no succes. My objetive is that rows that aren't between the LS and LI must be classified as the last one in this rank. Any idea how to solve that?
var Desvio = STDEVX.P(ALLSELECTED(fStatusInvest),[Total CAGR RECEITAS])
var Media = AVERAGEX(ALLSELECTED(fStatusInvest),[Total CAGR RECEITAS])
var Multiplo = [Total CAGR RECEITAS]
var LS = Media + 2.5*Desvio
var LI = Media - 2.5*Desvio
var rankeamento1 =
RANKX(
FILTER(
ALLSELECTED(fStatusInvest),
[Total CAGR RECEITAS] <= Media + 2.5*Desvio &&
[Total CAGR RECEITAS] >= Media - 2.5*Desvio &&
[Total CAGR RECEITAS] <> BLANK()),
[Total CAGR RECEITAS],
,
DESC,
Dense
)
var MaxRank = Maxx(fStatusInvest, rankeamento1)
Return IF(
Multiplo = BLANK(),
BLANK(),
IF(
Multiplo >= LS || Multiplo <= LI,
MaxRank,
rankeamento1
)
)
Hi, @ArlenioPaiva
Have your problem been solved? @MFelix said is reasonable. If you still need help, Can you share some sample fake data and your desired result?So we can help you soon.
Best Regards
Janey Guo
So, i havent solved yet.
I will share with you, if you can help i will appreciate.
How can i share? I tried here, but with no success
Hi @ArlenioPaiva ,
your explanation is not very clear about your data however believe that you need to do a summarize on your maxrank instead of linking the table directly something similar to this:
MaxRank =
MAXX (
SUMMARIZE ( fStatusInvest, fStatusInvest[Column], "@Rankeamento", rankeamento1 ),
[@Rankeamento]
)
Be aware that since I don't know your data granularity I only used a column but you must include in the summarize all the columns that make part of your context.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsFirst of All, thank you for your tentative.
But i didnt have success with it.
Could i share my project with you to see the problem?
thank you
Hi @ArlenioPaiva ,
Please do.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêshttps://drive.google.com/drive/folders/18JrGxpcVXwrAshdCDWtv1XM_i1e_Rdun?usp=sharing
here is the link with files guys.
Could someone help me?
I'm not able to solve the problem until now
Hi, @ArlenioPaiva
I checked your file, and found that you seem to have solved this problem, right?
Is this result you want, do you still need help?
Best Regards
Janey Guo
I solved the problem but i dont know if i have solved it correctly. But thanks for your help
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 |
---|---|
108 | |
98 | |
79 | |
66 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |