Forum Discussion
Solved
Cost Per Formula Help
So what I need is to know how to create what I assume would have to be a "Cost Per" measure. So the example is related to students. Every student costs $200 to instruct. I have a column called "Re...
Hi JMWDBA，
Based on your description, I make a test using the sample data below.
Firstly, create new columns using formulas below.
Cost of instuctions = 200
revenue = Table2[Course Price]-Table2[Cost of instuctions]Secondly, do you want to calculate distinct registration or full registration? For the former, create a measure using DAX: Distinct registrations = DISTINCTCOUNT(Table2[Registrations]). For the latter, create a measure using DAX: full registrations = COUNT(Table2[Registrations]).
Thirdly, create card visuals to display total registrations and revenue.
If the above steps doesn’t help, please share sample data of your table and post expected result here.
Thanks,
Lydia Zhang
