Hi Guys,
I have developed fax experience just a month ago. Now i am stuck in something with respect to aggregation when using Sumx.
Scenario: i have a measure 'Buy 1' from table 1. Now in table 2, i am using this measure and then comparing with existing another measure 'Buy 2' in table 2.
My code is
If (hasonefilter(material),
Min(buy1, sum(buy2)),
Sumx(table2, min(buy1,buy2))
)
This is not working..
Can anyone please assist me for this fax expression?? This is bug in my production dashboard and i need to resolve asap.
Any hints will be highly appreciated.
Thanks