topic Need DAX formula to get value by filter in DAX Commands and Tips

Need DAX formula to get value by filter

Elofly — Fri, 02 Feb 2024 11:31:39 GMT

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

Dangar332 — Fri, 02 Feb 2024 13:43:19 GMT

hi, Elofly

try below measure

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

talespin — Sat, 03 Feb 2024 18:26:26 GMT

Created a sample table, below is the measure.

TotalCount =

SUMX(

FILTER(

ADDCOLUMNS(

SUMMARIZE(TestTbl3, TestTbl3[Booking]

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

[CountBooking] > 1

[CountBooking]

)