How to summarize /group by/ count measure values

Question

Hi all,&nbsp;I have trouble with grouping measure values. I have table events with columns: Product,&nbsp; measure Price1 (p1) and then created measure Price2 (p2) from p1, and then Differece between these two prices (Diff), also a measure:Product&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;p1(measure)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;p2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (measure)&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Diff&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(p1-p2)&nbsp;a1&nbsp; &nbsp; &nbsp;5,525&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,515&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,010b2&nbsp; &nbsp; &nbsp;5,535&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,515&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,020b4&nbsp; &nbsp; &nbsp; 5,525&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,505&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,020b6&nbsp; &nbsp; &nbsp; 5,520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,510&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,010c3&nbsp; &nbsp; &nbsp; 5,520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,020c5&nbsp; &nbsp; &nbsp; 5,525&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,005a5&nbsp; &nbsp; &nbsp; 5,530&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,510&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,020d2&nbsp; &nbsp; &nbsp; 5,505&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,005d4&nbsp; &nbsp; &nbsp; 5,525&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,520&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,005&nbsp;Now I want to group (count) these differences in this way, Value 0,005 is shown 3 times in table, 0,010 is shown 2 times, etc.:DiffTotal0,005&nbsp; &nbsp; &nbsp;30,010&nbsp; &nbsp; &nbsp;20,020&nbsp; &nbsp; &nbsp;4&nbsp;but it doesn't allow me to group measure valus.(The CALCULATE&nbsp; function cannot be used in an expression argument for the GROUPBY() function.)Any ideas how to do this?&nbsp;Thanks!

johnt75 · Answer

Have a look at the dynamic segmentation DAX pattern.

freemanz · Answer

hi&nbsp;Anonymous&nbsp;following your description, you may try to create a measure like this:&nbsp;Measure = 
VAR _table1 = 
ADDCOLUMNS(
    SUMMRIZE(
        Products,
        Products[Product],
        Products[P1]
    ),
    "p2", [p2]
)
VAR _table2 = 
ADDCOLUMNS(
    _table1,
    "Diff",
    Products[p1]-[p2]
)
VAR _diff = SELECTEDVALUE(SegmentTable[Diff])
RETURN
COUNTROWS(FILTER(_table2), [Diff]= _diff )&nbsp;The measure is supposed to plot a table visual with the SegmentTable[Diff] column. The Products table and SegmentTable are unrelated.if case of issue, please consider providing some sample data.

anonymous · Answer

Hi&nbsp;FreemanZ&nbsp;,&nbsp;Unfortunatelly it is not working. Also p1 is a measure, and it is all one same table (Events).it is not allow me to add in selectedvalue a measure&nbsp;&nbsp;

anonymous · Answer

I resolved this issue in a way that I created new table from existing one with a Diff as a column. And then regular DISTINCTCOUNT works.&nbsp;

Forum Discussion

How to summarize /group by/ count measure values

4 Replies

Related content

Grouping Measures into categories

Parameter in summarize

Measure with SUMMARIZE

SUMMARIZE FUNCTION in measures

Don't Summarize....still summarizes...?

Product	p1 (measure)	p2 (measure)	Diff (p1-p2)
a1	5,525	5,515	0,010
b2	5,535	5,515	0,020
b4	5,525	5,505	0,020
b6	5,520	5,510	0,010
c3	5,520	5,500	0,020
c5	5,525	5,520	0,005
a5	5,530	5,510	0,020
d2	5,505	5,500	0,005
d4	5,525	5,520	0,005