Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get the MAX SUM except for this data

Previously I had an issue that Zubair_Muhammad solved here : https://community.powerbi.com/t5/Desktop/Matrix-Total-in-a-measure-doesn-t-sum-up/m-p/729524#M352008   I needed to get the max sum value...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

Try this modification

 

Inscription =
IF (
    HASONEFILTER ( 'Canaux Online'[Canaux Online] ),
    [InscriptionMeasure],
    SUMX (
        EXCEPT ( VALUES ( 'Canaux Online'[Canaux Online] ), { "SMO" } ),
        [InscriptionMeasure]
    )
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Zubair_Muhammad 

It doesn't seem to do anything.

 

Also even if I can exclude the SMO part, how can I add in place the SUM from the other source ?

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    HI, Anonymous 

    It should work well, if you want conditional from other source, you could try this way

    Inscription 33 = 
IF (
    HASONEFILTER ( 'Canaux Online'[Canaux Online] ),
    [InscriptionMeasure],
    SUMX (
        EXCEPT ( VALUES ( 'Canaux Online'[Canaux Online] ), VALUES('other source'[Canaux Online]) ),
        [InscriptionMeasure]
    )
)

    if possible, please share a simple sample pbix file for us have a test.

    You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

     

    Best Regards,

    Lin