Create new summary table

[SophRow]

Hi,

I have a table of sites and various metrics, and I created a calculated column to define 'Query age'

What I need is a new table that summarise query age > 1 months for each site, i.e.,

Not sure how to do this as Query age is a calculated column!

Thanks,

Soph

[Ashish_Mathur]

Hi,

to your Table visual, drag Site and this measure

Measure1 = calculate(countrows(Data),Data[Query Age]<>"<1 month")

Hope this helps.

[FreemanZ · Accepted solution]

try to create a new table with the code below:

Table =

ADDCOLUMNS(

    VALUES(TableName[Site]),

    ">1 month",

   CALCULATE(

        COUNTROWS(

            FILTER(

                TableName,

                TableName[Query age] <>"<1 month"

            )

        )

    )  

)

I tried and it works like this:

[SophRow]

Brilliant - thank you 🙂

[FreemanZ]

@SophRow  You are welcome. Is it qualified as a solution to your question?

[djurecicK2]

@SophRow 

Something like this- modify to fit your table and field names.

CountMeasure= CALCULATE(COUNT(Tablename[Query age]), FILTER(Tablename, Tablename[New Calculated Column]= TRUE))

Please consider accepting as solution if this has answered the question.

[djurecicK2]

Hi @SophRow ,

 You could create another calculated colum that is true or false depending on if the query age is > 1 month. Then use that column to filter your count.

[SophRow]

Thanks! I've created that column - can you share the DAX for the count?

[SophRow]

(basically how i get to the second excel example in my first post)