Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everybody,
I have 2 tables :
Table ZE :
Table GR :
I would like create a model like this :
Mois : Maxconfdate --> By month (table GR)
GR PC (table GR)
2 measures :
QTY_conf = CALCULATE(SUMMARIZE(ZE;ze[SUMQTYZE]);FILTER(ZE;ZE[Pur. Doc. Itm]=MAX(GR[Pur. Doc. Itm])))
Solved! Go to Solution.
Hi @LudivineLOU ,
I don't quite understand what value you want. May I ask how 550 is calculated? If you calculate the total, September should be 450.
QTY_conf = CALCULATE(SUM(ZE[SUMQTYZE]),FILTER(ZE,ZE[Pur. Doc. Itm]=MAX(GR[Pur. Doc. Itm])))
This measure you give is the max value of Purch item number. I filter the data for January as shown below, 800 is the maximum value, not the sum.
I found the PBI file from your other posts, and I found that there is no relationship between your two tables. I suggest you create a relationship and set up a both direction relationship so that you don't have to create MAXConfdate and QTYCONFIRMEDZE measures. Because two tables are equivalent to one table.
You only need to write a sum function to get the sum value, or max function to get the max value.
Sum = SUM('ZE'[SUMQTYZE])
Max = MAX('ZE'[SUMQTYZE])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LudivineLOU ,
I don't quite understand what value you want. May I ask how 550 is calculated? If you calculate the total, September should be 450.
QTY_conf = CALCULATE(SUM(ZE[SUMQTYZE]),FILTER(ZE,ZE[Pur. Doc. Itm]=MAX(GR[Pur. Doc. Itm])))
This measure you give is the max value of Purch item number. I filter the data for January as shown below, 800 is the maximum value, not the sum.
I found the PBI file from your other posts, and I found that there is no relationship between your two tables. I suggest you create a relationship and set up a both direction relationship so that you don't have to create MAXConfdate and QTYCONFIRMEDZE measures. Because two tables are equivalent to one table.
You only need to write a sum function to get the sum value, or max function to get the max value.
Sum = SUM('ZE'[SUMQTYZE])
Max = MAX('ZE'[SUMQTYZE])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |