Forum Discussion
Cost Per Formula Help
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
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
Yes, this did help immensely. Say I wanted to take it a step further. So the column named "Course" is a Concatenation of the column "Subject" and the column called "Catalog Number". If the catalog number is between 100-400 then the cost of instruction is $200 but if the catalog number is between 500-600 the cost of instruction is $300. How would i set this up so that I dont have to use a flat cost of instruction of $200?