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
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
