Calculate difference between values of filtered multi row card

[elijackson97]

Hey everyone, 

I'm pretty new to Power BI. I have pulled in some data with a bunch of columns that I'm trying to aggregate. I have one column that is a data type that indicates whether the rows are pertaining to projection data or not. In my report, I am trying to create a visual with calculations of all my data. One multi-row card filtered on the "projection" data type with sums of my data and different calculations, and one multi row card that is filtered as not "projection" data type.

I was able to create these cards successfully and do my calculations as needed, but I'm having trouble getting another card created with the differences between the "projection" and the "non-projection" data types. I would like to have 3 cards in total. One that is sums of all my columns for rows that have the "data-type" column as "projection", one that is sums of all my columns that have the "data-type" column as "non-projection", and one multi row card that calculates the differences between the projection and the non-projection (projection sums - non_projection sums)

Does anyone know how to go about doing this? 

edit: I realize I could create a new column that, if the data type is "projection" it is the value, and if it is not, is 0. I could do this for all columns I'm trying to calculate, and all data-types so that I could just do the sum of (projection_count - non_projection_count) but this isn't ideal. I simplified my issue to just 2 data types, but I actually have 3. I also have 19 values that I'm trying to calculate differences for, so doing it this method would mean adding I think 19 * 3 extra columns as new measures. I'd prefer not to do this just to keep my data fairly clean and easily understood. 

Thanks

[speedramps]

Click here to download the solution based on your question

Download PBIX 

We want to help you but your description is too vaugue. Please write it again clearly.

Please just give a simple non technical functional decscription of what you want, then let us suggest the DAX. Thank you.

Provide example input data as table text (not a screen print) so we can import the data to build a solution for you.
Also provide the example desired output, with a clear description of the process flow.

Remember not to share private data ... we don't want you to get into trouble. 😧

Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.

You will get a quick response if you put time, care and effort into writing clear problem descriptions.

Vaugue descriptions can waste your time and ourtime.

Look foward to helping you when the above information is forthcoming

[elijackson97]

I don't know a way to describe this much more non-technical. 

I have a table in Power BI (pulled from a SQL table) with membership columns that I want to sum along with a column called "data type" that is either "budget", "projection" or "YTD"

I want to have two tabs on my Power BI report. One that presents Projection vs Budget and one that presents YTD vs Projection. On each tab I want a multi row card (or other way to display the results) that sums the membership columns for budget and a seperate card that sums the membership columns for projection. I have done this successfully. I want to add a third card that takes the difference  between the two sums. The difference of the Projection vs Budget on one tab (and on the other tab the difference between the Projection and the YTD)

I have 19 columns of membership data that I'm trying to aggregate so I don't want to create a column that is like a SQL case statement, 0 if it's not projection and membership if it's projection, effectively creating 3 columns for each membership column I want to sum. This would be a solution but it would make my data too messy. I just want to find the differences between the values of the cards. On the Budget vs Projection tab, I have the card filtering the data_type value on the Budget card as "budget" and on the projection card it's filtering the rows that have the data type "projection" 

How do I just simply do the differences between the two values of the two selected cards? Since the cards are each filtering on the data type, I can't just subtract them, as including all the data types to subtract would cause an issue.