Forum Discussion
How to filter using the aggregated column after summarize
Hello,
I got a problem and I really want your suggestion.
I have this scenario
ClientId Project Creation_Project platforme
A PR1 01/01/2022 P1
A PR2 01/02/2022 P2
B PR3 01/01/2022 P1
B PR4 15/02/2022 P1
I want this result : wich platform got me the first project
First_touch
P1 : 2
P2 : 1
Last touch : wich platform got me the last project
P1 : 1
P2 : 1
In this case I need two measure First_touch_Platform and Last_Touch_Platform
wich consist on sumarazing by client and selecting the first / Last platform associated with the Min/max Date_creation
I Did this for the LastTouch ( the same logic for the firstTouch but unsing Min(client_plat[Creation_Project ])
LT_PT =
Note :
The calculation of the measure should not be affected by the Platform ( we need to filter after the calculation otherwise I will have this wich is not correct )
First_touch
P1 : 2
P2 : 1
Last touch : wich platform got me the last project
P1 : 2 ==> false
P2 : 1
NoaLowraee , Try measures like
First Val=
var _min = calculate(min(Table[Creation_Project]), filter(allselected(Table), Table[Client] = min(Table[Client])))
return
CALCULATE(Count(Table[Project]), filter( (Table), Table[Client] = max(Table[Client]) && Client[Creation_Project] =_min))Sum First Val = sumx(VALUES(Table[Client]) , [First Val])
Last Val=
var _min = calculate(max(Table[Creation_Project]), filter(allselected(Table), Table[Client] = min(Table[Client])))
return
CALCULATE(Count(Table[Project]), filter( (Table), Table[Client] = max(Table[Client]) && Client[Creation_Project] =_min))Sum Last Val = sumx(VALUES(Table[Client]) , [Last Val])
refer
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
2 Replies
NoaLowraee , Try measures like
First Val=
var _min = calculate(min(Table[Creation_Project]), filter(allselected(Table), Table[Client] = min(Table[Client])))
return
CALCULATE(Count(Table[Project]), filter( (Table), Table[Client] = max(Table[Client]) && Client[Creation_Project] =_min))Sum First Val = sumx(VALUES(Table[Client]) , [First Val])
Last Val=
var _min = calculate(max(Table[Creation_Project]), filter(allselected(Table), Table[Client] = min(Table[Client])))
return
CALCULATE(Count(Table[Project]), filter( (Table), Table[Client] = max(Table[Client]) && Client[Creation_Project] =_min))Sum Last Val = sumx(VALUES(Table[Client]) , [Last Val])
refer
Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
