Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |