Forum Discussion
Count by Measure Group
Hi mmyers2,
How did you count a measure? Maybe you need a Summarize to count a measure.
How did you create a visual? Maybe the formula can be simplified like this.
Cust Avg Qty/Wkly = AVERAGEX ( 'Cust Usage', SUM ( 'Cust Usage'[CUST_QTY_SHIPPED] ) )
And the report visual coule be:
'CUST Usage'[CUST_ID], 'CUST Usage'[PRODUCT_NUMBER], 'CUST Usage'[WEEK_OF_YEAR]), [Cust Avg Qty/Wkly]
About the visual you wanted, maybe you can create a table "MeasureValues" with the possible values of the measure. Then create a new measure like this:
New Measure =
VAR mvalue =
MAX ( MeasureValues[column] )
RETURN
SUMX ( 'table', IF ( 'table'[Old Measure] = mvalue, 1, 0 ) )Please give it a try.
Best Regards!
Dale
I tried the simplified weekly average, and it did not summerize correctly. I need the measure to summarize based on customer, product, and week, regardless of what I use it.
When I use the formula for a visual, here is what I get, which is not correct. This is what I get no matter what formula I use.
Surely there has to be a way to count records based on dynamic categories.
Here is an example of how it should look. I used static data in a table to create this, but I need it to be dynamic.
Anyone?
