SOLVED

Don't change slicer in power pivot

Brass Contributor

Dear friends

 

I have problem in power pivot , i want when we click on the slice the % profite fix and don´t change when we click on the pure invoice slicer, 

 

in other i want when we click on the slicer the % profit dont change, show the numbrs lie before cliking

 

How i can doing this? 

1 Reply
best response confirmed by Jalal_1988 (Brass Contributor)
Solution

@Jalal_1988 

You may remove the filter with

% PRFIT:=CALCULATE( [TOTAL PROFIT]/[TOTAL COST],
         ALL(DATA [Pur_Invoice] )
 )
1 best response

Accepted Solutions
best response confirmed by Jalal_1988 (Brass Contributor)
Solution

@Jalal_1988 

You may remove the filter with

% PRFIT:=CALCULATE( [TOTAL PROFIT]/[TOTAL COST],
         ALL(DATA [Pur_Invoice] )
 )

View solution in original post