Count Concatenate Measure

Hi Aleiadeh ,

It's impossible to achieve such a table visual with only measures. It will return a single row like this:

And you want to select date dynamically via slicer, so it is impossible to create a calculated table as well.

Please try this:

Status Changes =
VAR _MINDATE =
    MINX ( 'Table(1)', 'Table(1)'[Attribute] )
VAR _MAXDATE =
    MAXX ( 'Table(1)', 'Table(1)'[Attribute] )
VAR _MINVALUE =
    CALCULATE (
        MAX ( 'Table(1)'[Value] ),
        FILTER ( 'Table(1)', 'Table(1)'[Attribute] = _MINDATE )
    )
VAR _MAXVALUE =
    CALCULATE (
        MAX ( 'Table(1)'[Value] ),
        FILTER ( 'Table(1)', 'Table(1)'[Attribute] = _MAXDATE )
    )
RETURN
    _MINVALUE & " - " & _MAXVALUE

COUNT =
VAR _T =
    SUMMARIZE (
        ALLSELECTED ( 'Table(1)' ),
        'Table(1)'[Bid No.],
        "NEW", [Status Changes]
    )
VAR _A = [Status Changes]
RETURN
    COUNTAX ( FILTER ( _T, [NEW] = _A ), [NEW] )

 Please add at least one column (Bid No) to the visualization.The final output is shown below:

Here is the pbix file.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.