Forum Discussion

novotnajk's avatar
novotnajk
Icon for Resolver I rankResolver I
6 years ago

Dividing Two Columns without denominator not changing

Hi again!   I have a table that contains a list of patients, called MASTER PATIENT [Patient ID]. I have another table that contains medical diagnoses by patients, date of service, and spend, calle...
Need Help
Show and Tell
v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi novotnajk ,

 

We have tested your shared table and measure, but get the expected result 5K.

 

Per Patient Per Year = CALCULATE(DIVIDE(SUM('MASTER MEDICAL'[Spend]),CALCULATE(DISTINCTCOUNT('MASTER PATIENT'[Patient ID]))))


Could you please provide more details about it?

 

BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.