Filter based on Cell and not total of measure

[Nancyvilla]

I have a matrix that uses a measure called percent booked as the value, provider as the rows and the date as the column.  I would like to filter on when the percent booked is less than 75 for each day.  When I use one day in my filter, this works.  When I use the next 3 or 5 days, the filter is working on the total column and not the daily column.   Is there a solution for this?

Thanks,

Nancy

[Icey]

Hi @Nancyvilla ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @Nancyvilla ,

Is this what you want? PBIX file attached.

Measure =
DIVIDE (
    SUM ( 'Table'[Value] ),
    CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Provider] ) )
)

Measure 2 = IF ( [Measure] < 0.38, BLANK (), [Measure] )

Best Regards,
Icey

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

[Icey]

Hi @Nancyvilla ,

It would be great if you could tell me what you wanted in a concrete example.

Best Regards,

Icey