Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Thanks for any help you all can gather!
Solved! Go to Solution.
Hi, @Anonymous
Calculated Spread =[Filter First Security])-[Filter Second Security])
If the above measure doesn't work, you can try formula as below:
Calculated Spread =
VAR tab =
SUMMARIZE (
'First Data',
'First Data'[Date],
//'First Data'[Security],
"measure1", [Filter First Security],
"measure2", [Filter Second Security]
)
RETURN
SUMX ( tab, [measure1] - [measure2] )
If it doesn't work, please share a sample file for further research.
Best Regards,
Community Support Team _ Eason
Hi, @Anonymous
Can you tell me if your problem is solved?
If it doesn't work, please a sample file for further research.
Best Regards,
Community Support Team _ Eason
Hi,
Typically difference measures should work simpy by subtracting the first measue from the second one. So a simple Calculate spread = [Filter First Security]-[Filter Second Security]. Is there a reason this doesn't work in your example?
Proud to be a Super User!
Thats what i thought as well, so you see my confusion. The measures are just filtering for the selected values, so i wouldnt think that would cause an issue, but it seems to want to register them seperately as opposed to combining them. I could try removing the calculate function and see if thats the issue, but otherwise, im lost as to why it doesnt want to simply subtract the values
Hi, @Anonymous
Calculated Spread =[Filter First Security])-[Filter Second Security])
If the above measure doesn't work, you can try formula as below:
Calculated Spread =
VAR tab =
SUMMARIZE (
'First Data',
'First Data'[Date],
//'First Data'[Security],
"measure1", [Filter First Security],
"measure2", [Filter Second Security]
)
RETURN
SUMX ( tab, [measure1] - [measure2] )
If it doesn't work, please share a sample file for further research.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
13 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
21 |