Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
Below is the data i have:
Table 1:
Code | RV |
2017-00145 | 40.3 |
2017-11401 | 30.85 |
2017-00142 | 22.3 |
2017-11101 | 2.75 |
2017-1036F | 2.74 |
2017-17000 | 2.5 |
2017-12031 | 2.45 |
2017-11100 | 1.27 |
2017-00140 | 1.25 |
2017-11402 | 1.22 |
2017-17003 | 1.22 |
2017-11042 | 0.6 |
Table 2:
LOB | Name | Code |
MED | MAC | 2017-00140 |
MED | MAC | 2017-00142 |
MED | MAC | 2017-00145 |
MED | SWD | 2017-1036F |
Not Specified | SWD | 2017-1036F |
COM | MRJ | 2017-11042 |
COM | RTD | 2017-11100 |
COM | RTD | 2017-11101 |
MED | RTD | 2017-11101 |
COM | RTD | 2017-11401 |
MED | RTD | 2017-11401 |
COM | RTD | 2017-11402 |
MED | RTD | 2017-11402 |
COM | RTD | 2017-12031 |
MED | RTD | 2017-12031 |
COM | RTD | 2017-17000 |
MED | RTD | 2017-17000 |
MED | RTD | 2017-17003 |
Table 1 and Table 2 is joined by code with 1 to M relationship having cross filter direction enabled (BOTH).
Expected Result:
Name | RV | Measure |
MRJ | 0.6 | |
MAC | 63.85 | |
RTD | 42.26 | 63.85 |
SWD | 2.74 |
In the "Measure" above i need max of the "RV" displayed only for Name="RTD".
can anyone help? i tried so many ways, but ended up with 42.26 itself...
Solved! Go to Solution.
Measure = VAR myTable = SUMMARIZE(ALL(Table2),Table2[Name],"RV",CALCULATE(SUM(Table1[RV]))) VAR theMax = MAXX(myTable,[RV]) RETURN IF(MAX([Name])="RTD",theMax,BLANK())
Measure = VAR myTable = SUMMARIZE(ALL(Table2),Table2[Name],"RV",CALCULATE(SUM(Table1[RV]))) VAR theMax = MAXX(myTable,[RV]) RETURN IF(MAX([Name])="RTD",theMax,BLANK())
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |