Forum Discussion

PeterBI's avatar
PeterBI
Icon for Helper I rankHelper I
9 years ago
Solved

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. ...
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    9 years ago

    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

PeterBI's avatar
PeterBI
Icon for Helper I rankHelper I
9 years ago

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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

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

  • PeterBI's avatar
    PeterBI
    Icon for Helper I rankHelper I
    9 years ago

    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

     

     

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      9 years ago

      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

       

      • PeterBI's avatar
        PeterBI
        Icon for Helper I rankHelper I
        9 years ago

        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