Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PeterBI
Helper I
Helper I

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

 

 

2017-08-30_175300.png2017-08-30_174719.png

 

 

1 ACCEPTED SOLUTION

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:

Table_setup_1.pngTable_Setup.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

7 REPLIES 7
MFelix
Super User
Super User

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:

 

 

Winnerquote.png

 

regards,

MFelix

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

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:

Table_setup_1.pngTable_Setup.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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?

2017-08-31_213557.png

 

Kind Regards

Peter

 

 

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.

2017-09-01 17-30-07.png

My Table shows only one of them and the Drilldown changes only the Value:

2017-09-01 17-33-05.png2017-09-01 17-34-41.png

 

Is there a hidden Setting?

 

Kind Regards

Peter

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.

 

T.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.