division that is connected to the filter

[Dani2112]

Hello everyone,

I was trying to have a report where you could filter the next information 

When I select for example the grafit in the field of 204 I woul like to get in the card hit rate the 204/2598, but what happens is that when i select the 204 the 2598 becomes 204 and the hit rate percentage becomes 100% could you please tell me how can I get the result of 8% that is the result of 204/2598, I want to do the same for the other columns

[Dani2112]

https://drive.google.com/file/d/1YflWeunsbW5VZjgTi6WnRA4IHFvNYBfF/view?usp=sharing, this is the link where the report is located

[danextian]

the link is private

[danextian]

Hi @Dani2112 

With just the information provided, try either of this:

=
DIVIDE (
    [numerator],
    CALCULATE ( [denominator], REMOVEFILTERS ( 'table'[2598column] ) )
)

=
DIVIDE ( [numerator], CALCULATE ( [denominator], ALL ( 'table'[2598column] ) ) )

[sudhisami_azure]

What is "grafit"? Where it is located? Can you attach a sample file?