Convert Quick Measure Value to Column

[iliaisyah]

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.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[iliaisyah]

https://app.powerbi.com/links/gvwyiTMTrc?ctid=b3a10deb-b783-4098-b047-656b2a9d1453&pbi_source=linkSh... 

here you go

[Ashish_Mathur]

That takes me to a sign-in page.  Upload the file to Google Drive/One Drive and share the download link of that file.

[lbendlin]

Sorry but you cannot create columns from measures. Only the other way round.