Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Subtracting Value

Hi Team,   I have data,   expected Remaining value,     Thanks, KV's
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi Anonymous ,

 

Refer to:

Measure = 
var total_ = CALCULATE(SUM('Table'[Qas(m)]),ALLEXCEPT('Table','Table'[size]))
return total_-MAX('Table'[Limit])

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi V-lianl-msft ,

     

    thanks for your reply,

     

    suppose Qas (m) and Limit is calculated column like new measure's then how do I calculate ?

     

    please help me.

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      If there is no sample file to view the measure details, there may be deviation.

      Please try:

      Measure = 
var total = SUMX(ALLEXCEPT('Table','Table'[Size]),[Measure(Qas)])
return total-[Measure(limit)]

      If the problem persists,could you share the sample pbix via cloud service like onedrive for business?

      Please remove any sensitive data before uploading.

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        data look like below, please update me (can't share pbi file)