Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
I want to calculate difference between two bonds in column "Bond" (e.g. A-B or B-D )based on a slicer. Also,i would need 2 slicers as i need to compare both differences on a timeseries chart.
I tried but unable to do it for multiple and could not make bond selection dynamic based on user selection
Example of data and result expected are as below.
Solved! Go to Solution.
@Adi57 Create 2 disconnected slicer tables and then a measure like:
Measure = 
  VAR __Slicer1 = MAX('Slicer1'[Bond])
  VAR __Slicer2 = MAX('Slicer2'[Bond])
  VAR __Bond1 = SUMX( FILTER( 'Table', [Bond] = __Slicer1 ), [Value] )
  VAR __Bond2 = SUMX( FILTER( 'Table', [Bond] = __Slicer2 ), [Value] )
  VAR __Result = __Bond1 - __Bond2
RETURN
  __Result@Adi57 Create 2 disconnected slicer tables and then a measure like:
Measure = 
  VAR __Slicer1 = MAX('Slicer1'[Bond])
  VAR __Slicer2 = MAX('Slicer2'[Bond])
  VAR __Bond1 = SUMX( FILTER( 'Table', [Bond] = __Slicer1 ), [Value] )
  VAR __Bond2 = SUMX( FILTER( 'Table', [Bond] = __Slicer2 ), [Value] )
  VAR __Result = __Bond1 - __Bond2
RETURN
  __Result 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |