Constant Calculated measure value with slicer interaction

[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 which I had worked but the issue is when i select the item in slicer both the numerator & denominator are getting interacted. I need to have constant denominator value whcih ever i select the slicer item.

Thanks in advance.

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test, we can create the measures as below to meet your requirement.

Numerator = SUM(Table1[Resolved Inflow-Numerator])

denominator = CALCULATE(SUM(Table1[Inflow-Denominator]),ALL(Table1))

% = [Numerator]/[denominator]

Then we can get result as below.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/3ixd8nuemeksias/Constant%20Calculated%20measure%20value%20with%20slicer%20interaction.pbix?dl=0

Regards,

Frank