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