Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incorrect Status based on Minimum value

Hi all, Am stuck in a situation that I cant seem to solve, still learning so would appreciate if you could tell me what am I doing wrong and how do I get this right? It seems simple, but not for me ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi HotChilli,

 

You are right, the min value calculation is done using a measure and the Status is calculated using a calculated column. I need to be able to use "Status" as a slicer so I dont know if I can calculate Status as a measure. 

 

I tried using a calculated column to calculate min value and it just wouldnt show the right numbers.

 

Screenshot with stores with new calculations:

Screenshot without stores with new calculations:

I was hoping to get the results as below for

-without stores

with stores - 

Link to pbix file here:

https://drive.google.com/open?id=12E1eD1Gy88OUvmcalzO_e_mJ3rRKveGP 

 

Thank you so much for your help here HotChilli.

 

Please let me know your thoughts here.

HotChilli's avatar
HotChilli
Community Champion
7 years ago

I think you've solved the 'with stores' column formula.

The same formula won't work for 'without stores'.  Remember, you will need 2 columns if you're going down this route.

The other column would be

Chilli1.1 NEW - Min Price = CALCULATE(MIN(Data[Store Price]),ALLEXCEPT(Data,Data[Barcode],Data[City],Data[Match Type]))

I think (though please test at your side)