Monday, May 6, 2013

Measures, Non-Measures, or a Combo in Power View

If you are new to using Power View you may notice that there are images on the left of the available fields in the Field List:

When you are creating your visualizations it is important to know what numbers you can see and what they can be sliced by:  E.g. Product Profit by Sales Number.

Numbers are Measures represented by the Calculator. E.g. Product Cost & Product Profit above.

Slicers are Non-Measures represented by no image. E.g. Sales Category above.

Combo is represented by the greek letter Sigma. E.g. SalesNumber above.

So lets drag them into a blank Power View report to demonstrate the above.

Product Profit sliced by Sales Category and Count of SalesNumber.

When using the combo field SalesNumber I chose to a Distinct Count of SalesNumber to show SalesNumber as a Measure to answer the business question how many Sales were attained. This can be done in the Layout Section which is directly below the Fields List section in Power View.


To change the combo field SalesNumber from a Measure to a Non-Measure or Slicer, simply select the "Do Not Summarize" option and you will notice it change in Power View as below to answer how much profit per transaction was attained:

I will be explaining this in further detail and covering a lot of other material about Power View this Wednesday night May 8, 2013 at the MSBI South Florida User Group event at 6 pm. More info on the event is here and hope to see you all there!

No comments:

Post a Comment