Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi 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
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |