Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Interaction causes invalid calculation

Somehow when I'm clicking on bars it messes up my % calculation. Do I need to alter the calcuation?   Here is what I've done:  Created custom column to determine if a claim is electronic or paper ...
  • Anonymous's avatar
    Anonymous
    6 years ago
    [Total Claims] = SUM ( 'Table'[ Claim Count] )

[% Electronic] =
var __electronicClaims =
	CALCULATE ( 
		[Total Claims],
		KEEPFILTERS(
			'Table'[Claim Type] = "Electronic"
		)
	)
var __totalClaims = [Total Claims]
return
	DIVIDE(
		__electronicClaims,
	    __totalClaims
	)

     

    Please learn about how filters interact with each other when you use them in CALCULATE.

     

    Best

    D

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

Since the counts are off after slicing it shows that it's not the calculation. Can't be the calculated column. Best to slice to a small selection and try to understand why these rows remain after slicing.