Forum Discussion

JMWDBA's avatar
JMWDBA
Advocate II
9 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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