Forum Discussion
Jalal_1988
Apr 16, 2024Brass Contributor
Don't change slicer in power pivot
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?
You may remove the filter with
% PRFIT:=CALCULATE( [TOTAL PROFIT]/[TOTAL COST], ALL(DATA [Pur_Invoice] ) )
1 Reply
- SergeiBaklanDiamond Contributor
You may remove the filter with
% PRFIT:=CALCULATE( [TOTAL PROFIT]/[TOTAL COST], ALL(DATA [Pur_Invoice] ) )