Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago
Solved

A single value in column [CMI] in file....cannot be determined...

Hello all--yes, this is a very common error.  Part of the DAX learning experience I guess.  There are many variations it seems.    The measures (derived from measures) I'm looking to create are of ...
Need Help
ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago

Thanks very much.  I'll try it tomorrow!  Tom

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago

Greg_Deckler That worked great.  Here's the pattern I ended up using.

 

XXX Adj =
// Each facility is a single scalar, but the totals are an average of the CMI's--and not adjusted
// for the case counts in each facility
VAR CMIVAL = DIVIDE(SUMX(FR2015_standardizing_file, [CMI]),COUNTX(FR2015_standardizing_file,[CMI]))
RETURN
(DIVIDE([XXX],CMIVAL))

 

Thanks,

Tom