cancel
Showing results for
Did you mean:
PeterBI Regular Visitor

## Creating and Using Measures in this Example

Hello,

I just started with PowerBI and need a little Help in creating measures and using it in a view.

I have the following Table with a relation to the datekey Table and the Idea for the view.

So my first question is the creation of the measure to calculate the WinnerQuote and the second question is using it to calculate the view for the weekly and the monthly numbers.

Thanks for an Idea for the Solution,

Peter

PBIX File

Excel File  1 ACCEPTED SOLUTION

Accepted Solutions Super User

## Re: Creating and Using Measures in this Example

Hi @PeterBI,

First of all I just complicated the measure a lot just use this and it works perfectly good:

```WinnerQuote =
DIVIDE (
CALCULATE ( COUNT ( Winner[Winner] ), Winner[Winner] = 1 ),
CALCULATE ( COUNT ( Winner[Winner] ) )
)```

Just being hard because of a different problem I had before.

Regarding the setup of the table here is the full menu copy:  Regards,

MFelix

Proud to be a Datanaut!

7 REPLIES 7 Super User

## Re: Creating and Using Measures in this Example

Hi @PeterBI,

First of all don't know if your example in the Excel is based on the values you have in your PBIX file but add this measure:

```WinnerQuote =
VAR WeekValue =
MIN ( DateKey[Week] )
RETURN
IF (
MAX ( DateKey[Week] ) = WeekValue,
DIVIDE (
CALCULATE ( COUNT ( Winner[Winner] ), Winner[Winner] = 1 ),
CALCULATE ( COUNT ( Winner[Winner] ), DateKey[Week] = WeekValue )
),
DIVIDE (
CALCULATE ( COUNT ( Winner[Winner] ), Winner[Winner] = 1 ),
CALCULATE ( COUNT ( Winner[Winner] ), DateKey[Week] = DateKey[Week] )
)
)```

The result is as follow: regards,

MFelix

Proud to be a Datanaut!

PeterBI Regular Visitor

## Re: Creating and Using Measures in this Example

Hi MFelix,

Thank You Very much. Is it possible to post a screenshot from the Visu Menue where you configure the Table?

Kind Regards

Peter Super User

## Re: Creating and Using Measures in this Example

Hi @PeterBI,

First of all I just complicated the measure a lot just use this and it works perfectly good:

```WinnerQuote =
DIVIDE (
CALCULATE ( COUNT ( Winner[Winner] ), Winner[Winner] = 1 ),
CALCULATE ( COUNT ( Winner[Winner] ) )
)```

Just being hard because of a different problem I had before.

Regarding the setup of the table here is the full menu copy:  Regards,

MFelix

Proud to be a Datanaut!

PeterBI Regular Visitor

## Re: Creating and Using Measures in this Example

Hi MFelix,

Thanks again. I'm using this example to learn DAX so please excuse the next question, if it is so simple ;-)

Where do you get the Values? Are there aditionally measures? Can you send me the PBIX File? Kind Regards

Peter Super User

## Re: Creating and Using Measures in this Example

Hi @PeterBI,

The values are all of the columns in your file however I have used the summarized options and also made the change of one of the columns:

Number of trades = Count of Winner - rename it (double click on the Values field)

Winner count = Sum of Winner - rename it (double click on the Values field)

Winner Quote = Measure created

Revenue = Sum of Revenue

Here is the PBIX file updated.

Any questions please feel free to send a message.

Regards,

MFelix

Proud to be a Datanaut!

PeterBI Regular Visitor

## Re: Creating and Using Measures in this Example

Hi MFelix,

first of all "Thank You Very Much"

It is an elegant Measure and you helped me in understanding Measures and using them.

I recreated in another Dataset and it worked very well. Its my first Pivot Table and every new Beginning is hard.

One small Question: In your Table you have Year, Month Number and Week next to each other. My Table shows only one of them and the Drilldown changes only the Value:  Is there a hidden Setting?

Kind Regards

Peter Super User

## Re: Creating and Using Measures in this Example

Hi @PeterBI,

In the options on the Row Header you need to tick off the Stepped layout and click the last button on the drill down the two linked arrows on the right, then you will get that view. Regards,

MFelix