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.
Hello everybody!
I need some help please:
I have a table with a few columns and I want to make a mesure with the sum of 2 columns, and the maximum of one of them. All this need to be filter by the other column: Look at my example: I have the first table and i want to get the 2nd one. If I Change the filter date, I want my second table refresh.
I have a good track, but my filter date is desactivate with it:
Solved! Go to Solution.
Hi @GyMpX ,
We can create measures in new table [Filtre Date].
Nb1 =
SUM(Fichiers[nombre])
MAX NB Zone1 =
var _table=SUMMARIZE(ALLSelected('Fichiers'),Fichiers[zone],'Fichiers'[Produit],"Nb",[Nb1])
return
MAXX(FILTER(_table,[zone]=MAX('Fichiers'[zone])),[Nb])
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ohh!!! It's fantastic! It's work!!!!!!! You are a genus, Thank you a lot!
Hi @GyMpX ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) We can create a table.
Filtre Date =
var _table=
SUMMARIZE('Fichiers',Fichiers[zone],Fichiers[Produit],"Nb",SUM(Fichiers[nombre]))
return
ADDCOLUMNS(_table,"MAX NB Zone",MAXX(FILTER(_table,[zone]=EARLIER([zone])),[Nb]))
(3) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you a lot for your answer!
But i have always a problem if i want to add a filter on the date (which is present in my first table). I prefer create a measure. and I think A little thing miss in my request.
Hi @GyMpX ,
We can create measures in new table [Filtre Date].
Nb1 =
SUM(Fichiers[nombre])
MAX NB Zone1 =
var _table=SUMMARIZE(ALLSelected('Fichiers'),Fichiers[zone],'Fichiers'[Produit],"Nb",[Nb1])
return
MAXX(FILTER(_table,[zone]=MAX('Fichiers'[zone])),[Nb])
Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In the second table, i would like to make Produit and not Expert sorry
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 |
---|---|
43 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
73 | |
47 | |
45 | |
17 | |
17 |