1 ACCEPTED SOLUTION
Hi,
Here are measures for this:
Prix2 =
var _model = MAX(Host2[Model])
var _sla = MAX(Host2[SLA])
var _location = MAX(Host2[Location])
RETURN
CALCULATE(MAX(Prix2[PRIX]),FILTER(all(Prix2),Prix2[Model]=_model&&Prix2[SLA]=_sla && CONTAINSSTRING(_location,[Location])))
End result:
You can also consider using functions like LEFT if the longer location always starts with the shorter location text.
Total2 =
var _model = MAX(Host2[Model])
var _sla = MAX(Host2[SLA])
var _location = MAX(Host2[Location])
RETURN
CALCULATE(MAX(Prix2[Total]),FILTER(all(Prix2),Prix2[Model]=_model&&Prix2[SLA]=_sla && CONTAINSSTRING(_location,[Location])))
End result:
You can also consider using functions like LEFT if the longer location always starts with the shorter location text.
Hi,
Here is one way to do this:
View =
var _vtable1 =
VAR _chost = MAX(Host[Host]) RETURN
ADDCOLUMNS(Host,"SLA Host",CALCULATE(MAX(SLA[SLA]),FILTER(SLA,Host[Host]=SLA[Host])))
RETURN
FILTER(CROSSJOIN(_vtable1,Prix),[SLA Host]=[SLA.1] && [Model]=[Model.1] && FIND([Location.1],[Location],,-1)>0)
End result:
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hi @ValtteriN
Thank you for your quick reply.
Could you please sugges other solution if possible to avoid adding a table but only a Table view
Tg
Hi @vnqt ,
In that case you can use MAXX with some modifications:
MAXX of view = var _vtable1 =
VAR _chost = MAX(Host[Host]) RETURN
ADDCOLUMNS(Host,"SLA Host",CALCULATE(MAX(SLA[SLA]),FILTER(SLA,Host[Host]=SLA[Host])))
var _vtable2=
FILTER(CROSSJOIN(_vtable1,Prix),[SLA Host]=[SLA.1] && [Model]=[Model.1] && FIND([Location.1],[Location],,-1)>0)
RETURN
MAXX(_vtable2,[PRIX])
This measure will return PRIX values based on the previous example.
using it in table view returns this:
This measure will return PRIX values based on the previous example.
using it in table view returns this:
Now you can do the same with total and add the columns you want.
Hi,
Here are measures for this:
Prix2 =
var _model = MAX(Host2[Model])
var _sla = MAX(Host2[SLA])
var _location = MAX(Host2[Location])
RETURN
CALCULATE(MAX(Prix2[PRIX]),FILTER(all(Prix2),Prix2[Model]=_model&&Prix2[SLA]=_sla && CONTAINSSTRING(_location,[Location])))
End result:
You can also consider using functions like LEFT if the longer location always starts with the shorter location text.
Total2 =
var _model = MAX(Host2[Model])
var _sla = MAX(Host2[SLA])
var _location = MAX(Host2[Location])
RETURN
CALCULATE(MAX(Prix2[Total]),FILTER(all(Prix2),Prix2[Model]=_model&&Prix2[SLA]=_sla && CONTAINSSTRING(_location,[Location])))
End result:
You can also consider using functions like LEFT if the longer location always starts with the shorter location text.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
