Forum Discussion
Constant Calculated measure value with slicer interaction
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.
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.
Regards,
Frank
1 Reply
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.
Regards,
Frank