Need DAX formula to get value by filter

[Elofly]

Hi everyone,

I need to calculate a value instead of having it in a matrix:

So this is the list of duplicate booking identificar and a count of how many bookings for each value.

But I have a filter applied to count ONLY when Bookings are superior to 1.

I need to calculate that value so i get the number 2584 in a card and so I can calculate some ratios.

I cannot find the formula to do it.

Thanks a lot in advance for your help

[talespin · Accepted solution]

hi @Elofly ,

Created a sample table, below is the measure.

TotalCount =

SUMX(

        FILTER(

                ADDCOLUMNS(

                            SUMMARIZE(TestTbl3, TestTbl3[Booking]

                            ),

                            "CountBooking", CALCULATE(COUNT(TestTbl3[Booking]))

                ),

                [CountBooking] > 1        

        ),

        [CountBooking]

)

[Dangar332]

hi, @Elofly 

try below  measure

measure =
countx(all('tablename'),'tablename'[bookingcolumn])