How to create a measure that calculates several data cards?

[PowerAutomater]

I have a few data cards providing totals, and I would now like to add another data card which performs some calculations on these data cards and produces the result in the new one. I would like to use a measure to perform these calculations but I am having trouble finding the data card results when writing the calculations. I've tried typing the data cards label into the measure formula bar but it is not finding it unfortunately.

Eg.

Measure1 = CALCULATE(DataCardLabel1 + DataCardLabel2)

Measure2 = CALCULATE(DataCardLabel3 + (DataCardLabel4/2))

What syntax do I need to use to find these in the measure formula?

[v-dineshya]

Hi @PowerAutomater ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Thank you

[Irwan]

hello @PowerAutomater 

i am not sure how your data model looks like, but if those DataCardLabel are measures, i think you can directly add them up.

Measure1 = [DataCardLabel1] + [DataCardLabel2]

Measure2 = [DataCardLabel3] + [DataCardLabel4]

Otherwise, please share your sample data that represent your original data.

Thank you.

[PowerAutomater]

No sorry the DataCardLabel#'s are where I would like to put the result of the various data cards, they are not measures.

[Irwan]

hello @PowerAutomater 

how do you do this "put the result of the various data cards"?

if this not measure, then is it a calculated column?

can you share some data and your desired outcome?

Thank you.

[PowerAutomater]

That is my question, is there a way to put the results of several data cards into a measure? Similar to how you can reference fields in measures and do calculations on them etc.

[Irwan]

hello @PowerAutomater 

not sure if i get what your goal.

what value do you put into your card?

card value is based on calculation therefor what value in your card to be referenced?

Thank you.

[PowerAutomater]

Ok how about I run through a simple version of what I'm trying to do to hopefully make it clearer:

1) Create a csv similar to this with several events and multiple dates for each (date overlap between events is fine)

2) Open PowerBi Desktop and create a new blank report

3) Get the csv data, both columns should come through in the format date and text automatically but feel free to double check

4) Setup the following 2 data cards

With all of that setup, my question now is how do I create a third data card which dynamically adds the result of the previous 2 data cards (6+19 in the current case), so that if the data is updated later with more events and more dates the third data card will automatically total both of them each time.

Hope this clarifies things, let me know if not

Edit: There is also a similar question here, but I couldn't work out how they reference the previous data cards in the measure