Forum Discussion

iliaisyah's avatar
iliaisyah
New Member
4 years ago

Convert Quick Measure Value to Column

Dear Friends,

I am totally a beginner and learn a lot from Youtube and Forum. but I have this n could not find solution

 

the situation - I have 2 columns, "fertilizer applied and Fertilizer Budget"

by using quick measure, i am able to calculate the variance as below :

fertiliser_qty - Budget Fertilizer

Afertiliser_qty - Applied Fertilizer

Quantity variance formula = VAR __BASELINE_VALUE = SUM('GTME_data'[fertiliser_qty])
VAR __VALUE_TO_COMPARE = SUM('GTME_data'[Afertiliser_qty])
RETURN
DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

 

and my field appears the "calculator" as Fertiliser % - because using a quick measure 

 

the problem now, i want to have this measure in a column for me to further used in the edit query to add a conditional column based on the quick measure criteria.

 

 

the intention is to further is to clasify 

if the value in variance = -100% = not applied

if in between -0% to -99% = In complete

if in the valuw is 0% - COMPLETED

if more than 0.1% to Max (positive) = Unbudgetted

 

thank you so much for your kind help as I need to submit this PBIX by 1st June. I try to google but I could not find it.

 

 

4 Replies