Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day to all
i got this data,
what i want to do is if i filter the Reference to 2 and the
sum of amount must be 300 coz of reference 1+2 = Amount 100+200
i use this formula " Sum({<Reference={"<=$(=Max(Reference))"}>}[Amount]) "
i got it right if i select in the filter 1 and 2 but it doest work if i select in the filter only the 2
Reference | Amount |
1 | 100 |
2 | 200 |
3 | 300 |
4 | 400 |
does anyone have an idea how to compute it
thanks...
Try like:
Sum({<Reference, HSL={"$(=Max(Reference))"}>}[Amount])
Hi there mate thanks for the help but it doesn't work as expected you coz if i filter the referece it always give me 1000 as sum of amount...
Thanks
Do you need to check it in the chart or in KPI object? And I don't see a field called HSL ?
I guess if it is the same field Reference, you could try:
Sum({<Reference={"<=$(=Max(Reference))"}>}[Amount])
oww sorry for that i posted the wrong formula
"Sum({<Reference={"$(<=Max(Reference))"}>}[Amount])" please
replace the HSL to Reference.
thanks for that.
Try the expression I showed above. Positioning of '<=' needs to be corrected.