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, I am having issued with my formula not summing up at the Total and Subtotal level. I would like to show me the sum in the subtototals and totals instead of Zeros (Because it is doing it linear)
Solved! Go to Solution.
Hi @svallejo ,
According to your description, I create a sample.
RR23 and Average RR23 are all measures.
RR23 = MAX('Table'[Sales])
Average RR 23 = MAX('Table'[Cost])
Here's my solution, create a measure.
Measure =
SUMX (
ADDCOLUMNS (
'Table',
"Diff",
IF ( [RR23] > [Average RR 23], [RR23] - [Average RR 23], 0 )
),
[Diff]
)
Get the correct result.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @svallejo ,
According to your description, I create a sample.
RR23 and Average RR23 are all measures.
RR23 = MAX('Table'[Sales])
Average RR 23 = MAX('Table'[Cost])
Here's my solution, create a measure.
Measure =
SUMX (
ADDCOLUMNS (
'Table',
"Diff",
IF ( [RR23] > [Average RR 23], [RR23] - [Average RR 23], 0 )
),
[Diff]
)
Get the correct result.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pls try this
opportunity 2= IF ( ISFILTER (category), Opportunity, 0)
Proud to be a Super User!
Hi,
it is not working. I am using the following formula but it does not seems to be calculating correcly.
what I essentially need is for the opportunity column to be = Return amount - Return $@ avg... but it is not doing it.
could you pls provide the sample data and expected output?
Proud to be a Super User!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |