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

Anonymous's avatar
Anonymous
Not applicable
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