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.
I build a matrix where one of the column is a measure that take the biggest number between data coming from 2 differents sources :
Inscription = SWITCH( TRUE(), SUM('Prod Asso Inscrites OnLine'[Inscription Prod]) > SUM('GA Asso Inscrites OnLine'[Associations Inscrites]), SUM('Prod Asso Inscrites OnLine'[Inscription Prod]), SUM('Prod Asso Inscrites OnLine'[Inscription Prod]) <= SUM('GA Asso Inscrites OnLine'[Associations Inscrites]), SUM('GA Asso Inscrites OnLine'[Associations Inscrites]) )
But as you can see the tota show me 3572 instead of 3813.
Solved! Go to Solution.
@Anonymous
Try this MEASURE which references your original measure
Idea is to sum up the MEASURE "Inscription" for all "Canaux Online" values
iNSCRIPTION2 = IF ( HASONEFILTER ( TableName[Canaux Online] ), [Inscription], SUMX ( VALUES ( TableName[Canaux Online] ), [Inscription] ) )
@Anonymous
Try this MEASURE which references your original measure
Idea is to sum up the MEASURE "Inscription" for all "Canaux Online" values
iNSCRIPTION2 = IF ( HASONEFILTER ( TableName[Canaux Online] ), [Inscription], SUMX ( VALUES ( TableName[Canaux Online] ), [Inscription] ) )
@Anonymous
Just Add this MEASURE in the MAtrix's Values section.
Replace TableName with your actual TableName
HI @Anonymous ,
Actually, you not need to use switch function. SWITCH function not suitable to handle summarize records, you can use max function to package these calculations to return the bigger one.
Inscription = MAX ( SUM ( 'Prod Asso Inscrites OnLine'[Inscription Prod] ), SUM ( 'GA Asso Inscrites OnLine'[Associations Inscrites] ) )
Regards,
Xiaoxin Sheng
Thank you @v-shex-msft but I changed the measure ans still have the same result for total.
User | Count |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |