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 all,
I have a strange behavior I do not understand,
I make multiple measures which are giving me the expected values
But then i want to use this result to a final step and it does not work..
Here's my report with information
I say,
If [Rank Pour Dispatch] <= [(1) Total des reliquats] Then 1 otherwise Blank()
But it does not work, Any idea?
Kind regards
@SebSchoon1 I made changes to this event and the event with the condition worked
But your data in the picture do not match what you provided
Wow,
may thanks for going into this,
it is strange that the date are different
here's another link with two examples
one where it works as expected.
and another one (just below)
Whioch does not work and i don't no why 😞
Hi @SebSchoon1 After examining the fascist sample data, I found that your measure (1) Total des reliquats gives the wrong value.
I suggest you use (1)Nombre entier Répartition in your event:
If(
[Rank Pour Dispatch] <= [(1)Nombre entier Répartition] && [Rank Pour Dispatch] <> BLANK() , 1, Blank())
Hello @DimaMD
Concerning the measure, it will not work since
if i have two items for 3 wharehouse it will not split the remaining quantities
since full number is 0 and remaining quantities = 0.67
it will not consider the total remaining quantities (0.67 * 3 ) = 2
So it will not work 🙂
@SebSchoon1 I'm sorry, after looking at your first post, I realized that you are not fulfilling the condition correctly,
Your condition should be like this change <= to >=
(1)Attribution des reliquats = If([Rank Pour Dispatch]<>blank() && [Rank Pour Dispatch] >= [(1) Total des reliquats] ,1,Blank())
Hello,
it does not work, since I'd like to Have Rank 1 As most important priority
:s I think that it must come from my [(1)Total de reliquats ARTICLE]
Wich seems to show results but if fact it is wrong.
Hello @DimaMD
thank you for having taken a glance on it.
May i ask you why the information i see on my table is not verified with IF measures?
my formula to test
It shows me "n" eve if my items are = to 2
here's my formula to obtain "(1)Total des reliquats"
@SebSchoon1 Yes, it is strange
hi @SebSchoon1 Try it
if = If [Rank Pour Dispatch] <= [(1) Total des reliquats],1, Blank()
Without sample data, it is difficult to conduct analyses
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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |