Create a hardcoded measure for a category that is not in the table

[DJBAJG]

Sorry, the title is a little confusing. Here's what I'm trying to do. In the picture below you will see two rows/categories; Employee and Family. They have associated rates. What I want to do is create a 3rd category that is Employee * 1.5; let's call it "EE*1.5" Measure-wise that's simple enough but I need it to appear as another row in the table hence needing, I beleive, to add that new category to the existing table. So the desired output would have 3 categories/rows: Employee, EE*1.5, Family.

Is there a way to do that or am I not thinking about it correctly? 

[parry2k]

@DJBAJG Yes, it has to be a row in a table (existing table with row added in PQ) or a new table created using PQ or DAX, your preference?

[parry2k]

@DJBAJG you have to add a row in Power Query or create another table in the DAX with the extra row. Let me know what you prefer and will send the solution accordingly.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[DJBAJG]

I think a new table would be the best solution.