Column value not to interact with slicer filter

[Anonymous]

Hi All,

Trying to get the denominator values(measure) as constant value even when I select the different values with power Bi slicer.

When I select A in the slicer my denominator measure should be always total of B Column as value 15. Only Numerator value should interact with the slicer.  The % value will be placed in a Card visual.

Thanks in advance.

[Pulkit · Accepted solution]

Hi Murali,

The DAX function ALL() may be able to help you in this.

example:

Measure =
var NUM = SUM(Column A)
var DEN = CALCULATE(SUM(Column B),ALL(Table))
return
DIVIDE(NUM,DEN)

[Anonymous]

Hi Pulkit,

Thanks for your solution which is the exact requiment.

You rocked!!!!!

Regards,

Murali

[dilumd]

% = Divide(Resolved Inflow - Numerator, SUM(inflow - Denominator)

[Anonymous]

Yes I to get from this dax, but when I select the slicer to B the denominator will change.