Forum Discussion

Anonymous

Not applicable

5 years ago

Subtracting Value

Hi Team, I have data, expected Remaining value, Thanks, KV's

Anonymous

Not applicable

5 years ago

thanks for your reply,

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

please help me.

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.