Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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)
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)
Hi Pulkit,
Thanks for your solution which is the exact requiment.
You rocked!!!!!
Regards,
Murali
% = Divide(Resolved Inflow - Numerator, SUM(inflow - Denominator)
Yes I to get from this dax, but when I select the slicer to B the denominator will change.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |