The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everybody, i have some question about this.
I have a table that contain multiple columns (Market, Despatch, etapa1). i have 1 MARKET, and a lot of despatch.
I need to find de max value of "ETAPA 1" Referred to each "DESPATCH" for example, in this case
And then calculate the addition with the max values
Solved! Go to Solution.
Hi @Anonymous
Thanks for reaching out to us.
>> And then calculate the addition with the max values
You can try this, create the 2 measures
Max_PerMarDes =
var _maxEta=CALCULATE(MAX('Table'[Etapa1]),ALLEXCEPT('Table','Table'[Market],'Table'[Despatch]))
return IF(MIN('Table'[Etapa1])=_maxEta,_maxEta)
sum = SUMX('Table',[Max_PerMarDes])
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Thanks for reaching out to us.
>> And then calculate the addition with the max values
You can try this, create the 2 measures
Max_PerMarDes =
var _maxEta=CALCULATE(MAX('Table'[Etapa1]),ALLEXCEPT('Table','Table'[Market],'Table'[Despatch]))
return IF(MIN('Table'[Etapa1])=_maxEta,_maxEta)
sum = SUMX('Table',[Max_PerMarDes])
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Please check the below picture and the attached pbix file.
It is for creating new columns.
MAX Etapa1 CC =
VAR _maxetapa1 =
MAXX (
FILTER (
Data,
Data[Market] = EARLIER ( Data[Market] )
&& Data[Despatch] = EARLIER ( Data[Despatch] )
),
Data[Etapa1]
)
VAR _condition = Data[Etapa1] = _maxetapa1
RETURN
DIVIDE ( _condition, _condition ) * _maxetapa1
MAX Etapa1 CC =
VAR _maxetapa1 =
MAXX (
FILTER (
Data,
Data[Market] = EARLIER ( Data[Market] )
&& Data[Despatch] = EARLIER ( Data[Despatch] )
),
Data[Etapa1]
)
VAR _condition = Data[Etapa1] = _maxetapa1
RETURN
DIVIDE ( _condition, _condition ) * _maxetapa1
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
14 | |
12 | |
6 | |
6 |